Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Want to disable scrollbar in split pane.

Hi,

Hoping that some kind soul can help me here.

My custom spreadsheet employs a split pane view. So there is a
vertical scrollbar for the
top pane and a vertical scrollbar for the lower, more important pane.

The lower pane contains the view which I do not want end-users to be
able to scroll out of view. Only the
data in the top pane should be changed at any time ( with the view in
the lower changing automatically
as their values are formula linked to the top pane ).

Is there any way I can remove the scrollbar from the lower pane?

Thanks for reading, your time is appreciated.

--
Kray10

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Want to disable scrollbar in split pane.

PS - In Tools/Options I can remove the scrollbar, but it removes both
of them (top and bottom pane).
It gets me closer to what I want to do, but the bottom pane is still
scrollable (with the mouse). Guess
I'm trying to lock the view of that pane. Possible?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Want to disable scrollbar in split pane.

You can Freeze Panes, but this only affects the top (and left) panes.
So if you change you layout so the top (not bottom) panes is static, it is
easy.

Otherwise, you may be able to work something in the _SelectionChange events,
check which Pane is active and .Select an appropriate cell. Not perfect, but
maybe you can play with this:

Dim PaneRange As Range
Dim LastCell As Range

Const PANETOWATCH As Long = 2

Private Sub Worksheet_Activate()

With ActiveWindow.Panes(PANETOWATCH ).VisibleRange
Set PaneRange = .Resize(.Rows.Count - 2, .Columns.Count - 2)
End With

Set LastCell = ActiveCell

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If ActiveWindow.ActivePane.Index = PANETOWATCH Then
If Intersect(Target, PaneRange) Is Nothing Then
LastCell.Select
Else
Set LastCell = Target
End If
End If

End Sub


NickHK

"Krayten" wrote in message
oups.com...
Hi,

Hoping that some kind soul can help me here.

My custom spreadsheet employs a split pane view. So there is a
vertical scrollbar for the
top pane and a vertical scrollbar for the lower, more important pane.

The lower pane contains the view which I do not want end-users to be
able to scroll out of view. Only the
data in the top pane should be changed at any time ( with the view in
the lower changing automatically
as their values are formula linked to the top pane ).

Is there any way I can remove the scrollbar from the lower pane?

Thanks for reading, your time is appreciated.

--
Kray10



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
How do I use freeze pane and split in the same excel spreadsheet Salam Excel Discussion (Misc queries) 2 August 25th 08 09:06 PM
Split, the vertical scrollbar is half way down the spreedsheet Kathy Excel Discussion (Misc queries) 2 April 20th 08 02:11 PM
Scrolling one pane only in a vertically split worksheet ODMV Excel Discussion (Misc queries) 4 April 3rd 08 02:50 AM
How To disable Alt Key Research Pane BobT Excel Discussion (Misc queries) 0 June 6th 06 01:16 PM
Excel should allow me to freeze pane in a split window MGB Excel Worksheet Functions 1 March 29th 05 05:50 PM


All times are GMT +1. The time now is 02:48 PM.

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"