Excel keeps track of the range and window layout that was active the last time you activated a worksheet and makes it active when you select the sheet again.
I want to create a macro which set the active range and window layout for several worksheets so that when the user selects the sheet I know what they are going to see.
I want to do this without actually selecting the worksheet in the macro.
Any suggestions.
I want to create a macro which set the active range and window layout for several worksheets so that when the user selects the sheet I know what they are going to see.
I want to do this without actually selecting the worksheet in the macro.
Any suggestions.