On Save Procedure Conumrum

[Ken Loomis]

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?

[Henry]

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" <[email protected]> wrote in message
news:[email protected]...
>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?
>
>
>