Excel Code to run ActiveWindow.View in normal view, only runs manually.

You can have different cells selections in three different sheets.... All you need to do is insert the following just before the End Sub.

Range("A1").Select
You may change A1 to your desired cell address in respective sheet

This has to done three times if e. g you have three sheets.. Goto every sheet vba viewcode
Private Sub Worksheet_Activate()
Ok. Like I did previously. When I was adding your code, I saw that there was 1 sheet that had this code .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = True
Do you have any advise?
 
Ok. Like I did previously. When I was adding your code, I saw that there was 1 sheet that had this code .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = True
Do you have any advise?
Let it be intact if not bothering..
Just locate the line which reads End Sub

Insert a line above End Sub..
 
Back
Top