Customizing a worksheet size

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

Guest

How do you reduce the size of a worksheet so that only 50 rows and/or a
select number of columns can be scrolled.
 
Elaine

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


Gord Dibben Excel MVP
 

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

Worksheet print sizing/scaling without impacting a logo image 2
Excel VBA - Problem with Closing Print Preview 0
Clear excess formats in Excel 2007 3
Excel File Size 9
Manipulating matrices of unknwon (a priori) size 1
matching & combining data from seperate worksheets 2
Worksheet(s) open to last used row 5
HOW DO I REDUCE THE SIZE OF A WORKSHEET TO THE CURRENT USED CELLS 6

Back
Top