LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Excel opens saved workbook without tabs or scroll bars showing? Dave W Franklin Excel Worksheet Functions 1 May 11th 05 11:11 PM
Impoting data from Sheet 1 to Sheet 2 a-leano Excel Discussion (Misc queries) 1 April 20th 05 01:05 AM
Scroll bars (vertical and horizontal). Doc Excel Discussion (Misc queries) 2 December 7th 04 03:33 PM
eliminate scroll bars where lists are short, show all choices rtejral Excel Discussion (Misc queries) 1 November 29th 04 09:01 PM


All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"