Excel: How can I freeze some of a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to freeze the unused cells so that I do not have to use the arrow
keys at the end of the data.
 
Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

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:M36"
End Sub


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 08:29:08 -0800, "Freeze unused cells" <Freeze unused
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Freeze animation 1
Freeze Panes loss 3
How Can I Insert A Column in A Spreadsheet With This Error Message 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Displaying zeros in cells 2
Freeze pane works in some workbooks but not others 1
Other users are freezing without knowing it?? 1
freeze pane doesn't work in my excel 2007 2

Back
Top