Remove Scroll Bars, etc on First Sheet Only

[Guest]

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!

 

[Jim Rech]

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