Need Excel startup macro to restore settings
Posted on 2001-08-04
We have a macro that starts when the workbook opens and works through each sheet. It protects sheets, hides columns, and resets things that may have been altered by the user.
The one thing it doesn't do is to set each sheet so that when it is opened by the user it displays the preferred start position (upper-left of the sheet) instead of where it was last left.
We also use "Freeze Panes" and that causes two other issues.
1)Our preferred "freeze point" is E8. Users may have scrolled right at the last session and when the sheet is re-opened columns A-D and R-Z are displayed instead of A-P.
2) Users may have moved the panes during the last session and we want to reset when opening.
Understand that we aren't trying to restrict the users during a session, we just want to reset each sheet to the standard start position the next time the workbook is opened.
Any help would be appreciated.