Save Excel Workbook
 

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

Save Excel Workbook
 

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

Save Excel Workbook
 

In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP

On Thu, 16 Oct 2008 17:34:19 +0200, "Juan García"
wrote:

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

Save Excel Workbook
 

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

"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje
...
In the Immediate Window

enableevents = false

Save the workbook then enableevents = true


Gord Dibben MS Excel MVP

On Thu, 16 Oct 2008 17:34:19 +0200, "Juan García"

wrote:

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