Gord and Dave,
I owe you both an apology: apparently, what I've always heard of as
"autosave" is actually labeled "autorecovery" -- this is what is doing the
automatic save every n minutes. I see that in the options form, the setting
says "Save Autorecovery information every ..."

I notice that the BeforeSave procedure does not get invoked when the
autorecovery save operation is performed. With respect to the initial issue
in this thread -- the desire to hide the workbook unless it is run with
macros on -- I'm not sure whether there is a large hole there that would be
saving the unhidden workbook in a file that could be later opened without
macors enabled. Have to do some testing.
--
Don H.


"Dave Peterson" wrote:

If you're using autosave (not autorecovery!!) in xl2003, then you're using an
older copy of that autosave.xla addin.

Autosave didn't come with xl2003 or xl2002.

donh wrote:

Gord, you may be correct about Excel 2002, but I'm using Excel 2003, and it
definitely has an autosave. In fact, we advise our users to leave it on, as
it means that no matter what bad thing happens to your machine, you will only
lose <n minutes of work. Many of our folks set it to about 10 minutes. As
you point out, Excel itself often recovers lost work with autorecovery, but
that isn't 100% reliable, I don't think.
--
Don H.

"Gord Dibben" wrote:

Excel 2002 doesn't have an Autosave operation.

It has an Autorecovery operation but that doesn't save the workbook and
overwrite the workbook or trigger the BeforeSave event.

Autorecovery just saves a copy of the workbook which is deleted if Excel and the
workbook don't crash.


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 08:56:02 -0700, donh wrote:

I've the same issue as "I Believe" -- this seems to be a recurring theme. It
would seem that the nice way to handle this would be for Microsoft to allow
an option on a workbook that says "Don't open this workbook if the user
doesn't enable macros" -- but that's another fish to fry.

Ron, your solution seems clever and fine, but with one gap that I don't see
how to fix: If the macro (that hides all sheets but one) runs before a save,
presumably using the WorkbookBeforeSave event, then how does one then unhide
the sheets to allow the user to continue working? I'm presuming that this
WorkbookBeforeSave event also gets triggered during autosave, in the middle
of a working session. There doesn't seem to be a WorkbookAfterSave event
that would allow one to unhide everything.



--

Dave Peterson