Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
labrev
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
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
Excel moving horizontal columns to vertical doulos Excel Discussion (Misc queries) 1 February 4th 05 07:01 PM
Scroll Bars Do Not Appear in Excel XP LeoMac Excel Discussion (Misc queries) 1 February 3rd 05 05:30 PM
In Excel 2000, how do I add a vertical scroll bar to a split scre. Lisa_196 Excel Discussion (Misc queries) 1 January 13th 05 10:12 PM
Excel, horizontal scroll bar and sheets not accessable anymore Cassandra Excel Discussion (Misc queries) 4 December 18th 04 06:01 PM
Scroll bars (vertical and horizontal). Doc Excel Discussion (Misc queries) 2 December 7th 04 04:33 PM


All times are GMT +1. The time now is 12:38 AM.

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

About Us

"It's about Microsoft Excel"