ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code Changes Not Executing (https://www.excelbanter.com/excel-programming/280359-code-changes-not-executing.html)

Justin[_8_]

Code Changes Not Executing
 
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.


Dave Peterson[_3_]

Code Changes Not Executing
 
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/

Justin wrote:

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.


--

Dave Peterson



All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com