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

Joined
Dec 13, 2017
Messages
71
Reaction score
19
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?
 
Joined
Feb 21, 2018
Messages
216
Reaction score
86
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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top