Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 01:25 AM
Brian
 
Posts: n/a
Default locking the scroll?

Hello,

I the portion of a worksheet that I currently have positioned so that it is
the only visible part of the sheet. But the scroll bar and the wheel on the
mouse can be used to move the sheet. What can I do to lock any scrolling?

Thank You
Brian

  #2   Report Post  
Old December 1st 04, 02:42 AM
Jason Morin
 
Posts: n/a
Default

Run a macro using:

ThisWorkbook.ActiveSheet.ScrollArea = "A1:J30"

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I the portion of a worksheet that I currently have

positioned so that it is
the only visible part of the sheet. But the scroll bar

and the wheel on the
mouse can be used to move the sheet. What can I do to

lock any scrolling?

Thank You
Brian
.

  #3   Report Post  
Old December 2nd 04, 12:49 AM
Gord Dibben
 
Posts: n/a
Default

Brian

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:J30"
End Sub

Gord Dibben Excel MVP

On Tue, 30 Nov 2004 18:42:31 -0800, "Jason Morin"
wrote:

Run a macro using:

ThisWorkbook.ActiveSheet.ScrollArea = "A1:J30"

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I the portion of a worksheet that I currently have

positioned so that it is
the only visible part of the sheet. But the scroll bar

and the wheel on the
mouse can be used to move the sheet. What can I do to

lock any scrolling?

Thank You
Brian
.


  #4   Report Post  
Old December 2nd 04, 01:06 AM
Cgbilliar
 
Posts: n/a
Default

Since no one has replied to your problem and I know very little myself you can
try to click on a cell at the bottom right corner of your sheet then click on
Windows, Freeze panes this may 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
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 09:12 PM
Excel, horizontal scroll bar and sheets not accessable anymore Cassandra Excel Discussion (Misc queries) 4 December 18th 04 05:01 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 05:39 PM
How do I add a scroll bar to my spreadsheet? huckleberry Excel Worksheet Functions 1 November 30th 04 06:19 PM
how to fit my column unmoved eventhough i scroll down? Zxing New Users to Excel 1 November 28th 04 06:28 AM


All times are GMT +1. The time now is 03:40 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017