Home |
Search |
Today's Posts |
#1
|
|||
|
|||
limit size of worksheet
I have created a doc in excel, but I don't want users to be able to scroll
down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob |
#2
|
|||
|
|||
-----Original Message----- I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob . You can use code Worksheets(name of sheet).ScrollArea = "a1:h60" Try this code Worksheets(name of sheet).ScrollArea = "" |
#3
|
|||
|
|||
"abfabrob" wrote in message ... I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob All you have to do is select the colums you want hidden and then select format - colum - and hide ... then repeat for rows.. if you accidently mess it up you can undo also. If you wish you can further protect it by selecting cells to be protected then format - cells ..protection tab, tick both boxes then return to Tools - protection - protect sheet...select each option and then choose a password. |
#4
|
|||
|
|||
Cheers!
" wrote: -----Original Message----- I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob . You can use code Worksheets(name of sheet).ScrollArea = "a1:h60" Try this code Worksheets(name of sheet).ScrollArea = "" |
#5
|
|||
|
|||
Thank you!
"Spider" wrote: "abfabrob" wrote in message ... I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob All you have to do is select the colums you want hidden and then select format - colum - and hide ... then repeat for rows.. if you accidently mess it up you can undo also. If you wish you can further protect it by selecting cells to be protected then format - cells ..protection tab, tick both boxes then return to Tools - protection - protect sheet...select each option and then choose a password. |
#6
|
|||
|
|||
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 Wed, 23 Mar 2005 06:41:05 -0800, "abfabrob" wrote: Cheers! " wrote: -----Original Message----- I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob . You can use code Worksheets(name of sheet).ScrollArea = "a1:h60" Try this code Worksheets(name of sheet).ScrollArea = "" |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
limit size of worksheet
Thanks a lot for Gord Dibben for his explanation, it is very useful.
"Gord Dibben" wrote: 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 Wed, 23 Mar 2005 06:41:05 -0800, "abfabrob" wrote: Cheers! " wrote: -----Original Message----- I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob . You can use code Worksheets(name of sheet).ScrollArea = "a1:h60" Try this code Worksheets(name of sheet).ScrollArea = "" |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
limit size of worksheet
Have a look at Anne's post he
http://www.microsoft.com/office/comm...d-0794b5bc2a32 "abfabrob" wrote: I have created a doc in excel, but I don't want users to be able to scroll down through the hundereds of empty cells below my two pages. Or scroll right across the hundreds of empty cells. Can I restrict the size of a work shhet to prevent this scrolling? Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the limit size for columns in Excel??? | Excel Discussion (Misc queries) | |||
Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
Customizing a worksheet size | Excel Worksheet Functions | |||
Increase default size of worksheet | New Users to Excel | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |