Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing two dates and executing code on condition ashish128 Excel Discussion (Misc queries) 4 August 31st 06 10:45 AM
QUERY & HELP: so slow executing VBA code... :S John Keith Excel Worksheet Functions 3 February 13th 06 03:47 PM
code sample for executing a VB function in Excel using perl newOLE Excel Worksheet Functions 7 August 10th 05 10:26 PM
Excel VBA code executing a variable as a Sub. John Dempsey Excel Programming 3 October 3rd 03 10:34 AM
executing code when a module opens max Excel Programming 0 July 8th 03 07:37 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"