View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Keep Before_Save from running

In the Before_Close add

ThisWorkbook.Saved = True

which will fool VBA into thinking no changes have been made.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Alex" wrote in message
...
I have some code in Before_Close that hides and unhides some sheets.

I also have some code in Before_Save that I only want run if the workbook

is
trying to be saved by the user, not if I'm the only thing being saved is

the
hiding and unhiding of the sheets that's taking place in the Before_Close
macro.

So, I was hoping there's a line of code I can write in the Before_Close
macro that will keep the Before_Save macro from running? Or is it

impossible
to keep the Before_Save macro from running since I'm really saving the

hiding
and unhiding of sheets? I hope that makes sense. Thank you.