Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel moving horizontal columns to vertical | Excel Discussion (Misc queries) | |||
Scroll Bars Do Not Appear in Excel XP | Excel Discussion (Misc queries) | |||
In Excel 2000, how do I add a vertical scroll bar to a split scre. | Excel Discussion (Misc queries) | |||
Excel, horizontal scroll bar and sheets not accessable anymore | Excel Discussion (Misc queries) | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) |