How can I reset Excel defaults for next workbook ?
Posted on 2001-08-10
We have a "Private Sub Workbook_Open()" macro that starts when a particular workbook opens and, among other things, hides the Formula Bar, Status Bar, and changes other settings for security and cosmetic reasons.
It work fine, but it leaves the Excel display defaults for other workbooks with the Formula Bar hidden and other setting modified - which we don't want.
Is there way to have something like a Workbook_Close macro to unhide the Formula Bar and restore the settings ?
Or another way ?
Anyhelp would be appreciated.