Save Excel Workbook

[Juan García]

How can I save an Excel Wokbook where I have disabled Save and Save As
options in the BeforeSave event?? I am the programmer not the user.
Thanks.-

 

[Jim Cone]

Add a stop at the beginning of the BeforeSave event code.
Save the workbook. When the code stops, move the cursor down
to the End Sub line and continue.
--
Jim Cone
Portland, Oregon USA


"Juan García"
wrote in message
How can I save an Excel Wokbook where I have disabled Save and Save As
options in the BeforeSave event?? I am the programmer not the user.
Thanks.-

 

[Gord Dibben]

In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP

 

[Juan García]

Gord, Jim... thanks a lot!!!!

In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP