How do I use a macro to set the range that will be active

[phg]

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.

 

[lenze]

To solve adding the code to each sheet, use the Activate event in the ThisWorkBook module
Easy if you want the same location on each sheet. If you want different anchor cells for each sheet, you will need to test for the sheet Name

Select Case ActiveSheet.Name
Case "CGSL" : Range("$A$1").Select
Case "XYZ" : Range ("$G$7").Select
'etc
End Select

lenze