When Sheet is moved the sheet vb code stays

V

Vic

I am moving a sheet from one spredsheet to another. There is three lines of code in VB editor for the sheet. The sheet moves to the new spreadsheet with the code through a macro (but the problem has been xcreated doing it manually as well). The problem is that the code is still in the original spreadsheet even though the actual sheet is not there anymore. XP can still open the file, but if the file is opened in 2000, it creates an immediate error and excel bombs out. How can I overcome this? It happens in both XP and 2000.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top