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. |
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. |
All times are GMT +1. The time now is 08:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com