View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Keep Before_Save from running

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.