It's an window property so it would affect all sheets (unless in an other
window). But you could use worksheet event code to remove them when that
sheet is activated, and reinstate them when it is not. Like so

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


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"labrev" wrote in 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