Open your workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer
Select your workbook's project
Insert|module
Paste that code into the newly opened code window.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Kelly wrote:

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


--

Dave Peterson