I do not want my sheet to update changes when i saveas the sheet. However, any other time i want the sheet to update automatically.
I know how to set calculating to manual using
I insert this code into the sub workbook_beforeSave() but my problem is that after the sheet saves, i need to turn it back toPlease Login or Register to view this content.
How can i do this? is there a built in sub that triggers after the workbook is saved?Please Login or Register to view this content.
Thanks
Schwizer
Bookmarks