- Joined
- Dec 13, 2017
- Messages
- 71
- Reaction score
- 19
Ok. Like I did previously. When I was adding your code, I saw that there was 1 sheet that had this codeYou 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()
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = True
Do you have any advise?