View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Henry[_5_] Henry[_5_] is offline
external usenet poster
 
Posts: 104
Default On Save Procedure Conumrum

Ken,

Open the workbook.
When the disable/enable macros dialog comes up, press & hold Shift and click
on enable.
You can now uncomment your code.
DO NOT RUN THE CODE.
Save the workbook.
Next time you open your workbook, it'll all work for you.

Henry

"Ken Loomis" wrote in message
...
I am almost done with this project. I have tested it thoroughly.

I even did a lot of testing of the Save event handler. Then I commented
out that entire sub to test the rest and make final adjustments. The Save
procedure denies letting the user save the file or to save a copy of the
file without removing all the code.

Now, I need to uncomment the Save procedure and then Save the workbook.
But if I do, I get caught in that procedure and can't save it with the
code intact.

Any suggestions about handling this conundrum?