horizontal & vertical scroll bars

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

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
>
>
>.
>

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" <labrev@discussions.microsoft.com> wrote in message
news:F94894A1-4568-4EDA-89AF-BD5731F0A5B0@microsoft.com...
> 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
>
>