Code Changes Not Executing

J

Justin

I have a spreadsheet with sub procedures in a module that
are run when the spreadsheet opens.
When I make code changes and save the changes and then
open the spreadsheet, the changes are not executed but the
previous ones are. The changes do come into effect
eventually but I have not discovered or realised what I
have to do to make this happen.

Your help much appreciated.
 
D

Dave Peterson

This sounds pretty unusual. Any chance you're saving to a new location, but
opening the old version?

If that's not it, you may want to try running Rob Bovey's code cleaner. It
exports each module, removes each, and reimports each. (It cleans up some
detritus that's left behind. You could it manually if you wanted.)

You can find it at:
http://www.appspro.com/
 

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