Right-click on the worksheet tab, go to View Code, and
insert the following:
Private Sub Worksheet_Activate()
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
End Sub
Private Sub Worksheet_Deactivate()
With ActiveWindow
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
End With
End Sub
---
HTH
Jason
Atlanta, GA
>-----Original Message-----
>I'm creating a spreadsheet which has a ' MENU 'sheet, so
users can navigate
>to other sheets within the spreadsheet via button clicks
on the 'MENU' sheet.
>Is it possible to remove the scoll bars from this 'MENU'
sheet but NOT from
>the
>other sheets.
>
>many thanks for any help
>
>
>.
>
Bookmarks