Horizontal Scroll Bars

[MasterChief]

I have a work book with a few sheets, The first one (Sheet 1) is just a text box giving instructions on how to use the workbook. So using options/tools I unchecked all the options refering to the scroll bars, how ever it applys this to the rest of the sheets. Is it possible to only change the options on one work sheet only and not the whole workbook ?

Hope this is clear.

Many Thanks

 

[Richard Schollar]

Hi Masterchief

You could include worksheet event code on Sheet1 along the lines of:

Private Sub Worksheet_Activate()
Application.DisplayScrollBars = False
End Sub

Private Sub Worksheet_Deactivate()
Application.DisplayScrollBars = True
End Sub

To activate/deactivate on the relevant sheet.

Best regards

Richard