Save Excel Workbook

J

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.-
 
J

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.-
 
G

Gord Dibben

In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP
 
J

Juan García

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

Gord Dibben said:
In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP
Click to expand...
 
Top