Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Scroll bars are window properties not worksheet properties so you're kind of
stuck. I think the only way to do this is a macro that fires when the active sheet changes. The macro would show scroll bars when you entered the title worksheet and hide them on leaving. If you want to try this, right click on the title page tab and pick "View Code". Then paste in this code: Private Sub Worksheet_Activate() ActiveWindow.DisplayHorizontalScrollBar = True ActiveWindow.DisplayVerticalScrollBar = True End Sub Private Sub Worksheet_Deactivate() ActiveWindow.DisplayHorizontalScrollBar = False ActiveWindow.DisplayVerticalScrollBar = False End Sub Of course the user would have to enable macros for this to work. -- Jim "Ray Lloyd" wrote in message ... | My Workbook has several Worksheets. It opens up on a Title Page from which | the viewer can navigate to other Worksheets. Is it possible to remove the | Scroll Bars and Tool Bars on this Worksheet only, thereby giving the Title | Page a more pleasing look and not affecting the other Sheets? | | ____________________ | Crime Pays... | Unless you''re a motorist! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) | |||
eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) |