Dave,

What are the steps to create this macro?
--
Kelly


"Dave Peterson" wrote:

One way is to disable events first.

In the VBE
show the immediate window
type this
application.enableevents = false
and hit enter

Then save your file.

Then turn events back on
application.enableevents = True

You may want to create a macro that does the same:

Option Explicit
Option Private Module
Sub SecretSave()
application.enableevents = false
thisworkbook.save
application.enableevents = true
End Sub



Kelly wrote:

I have an excel spreadsheet where I have cells that are mandatory to fill in.
I used the Before Save code in Thisworkbook and it worked. Now how can I
suspend this action so I can save the file myself?
--
Kelly

--

Dave Peterson