Scroll bar

[Wil Moosa]

My present workbook I am working on removes when opening all the controll bars and everything. This is as intended.

For one particular sheet however I need the scrollbar (and only the scroll bar).

What is the code for showing the scroll bar whenever I open this particular sheet and for hiding the scroll bar whenever I close the sheet?

Thanks again
This message was edited by Wil Moosa on 2002-11-17 13:25

 

[Haluk]

Hi;

You may try this for "Sheet2"; (place the code to ThisWorkbook part of the VBA)

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim data As Boolean
data = False
If Sh.Name = "Sheet2" Then data = True
ActiveWindow.DisplayHorizontalScrollBar = data
ActiveWindow.DisplayVerticalScrollBar = data
End Sub
This message was edited by Raider on 2002-11-17 13:47

 

[Wil Moosa]

It took me some time to figure it out and to get the train running but finally it did.

Çok tesekkür ederim... (don't think too much of it as I got it from the Lonely Planet).
This message was edited by Wil Moosa on 2002-11-17 19:05

 

[Haluk]

sorry for the missing explanation part but, it's nice to hear that the train is running...