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


Joined
Dec 13, 2017
Messages
60
Reaction score
16
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?
 
Ad

Advertisements

Joined
Feb 21, 2018
Messages
178
Reaction score
75
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

Similar Threads


Top