Save Excel Workbook

  • Thread starter Thread starter Juan García
  • Start date Start date
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.-
 
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.-
 
In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP
 
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...
 
Back
Top