Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
abfabrob
 
Posts: n/a
Default 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   Report Post  
 
Posts: n/a
Default


-----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   Report Post  
Spider
 
Posts: n/a
Default


"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   Report Post  
abfabrob
 
Posts: n/a
Default

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   Report Post  
abfabrob
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.excel.misc
Amd
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
ali
 
Posts: n/a
Default 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
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
What is the limit size for columns in Excel??? Melissa Excel Discussion (Misc queries) 5 May 16th 05 09:29 PM
Increase rows in worksheet beyond 65,536 row limit Ann Calantzis Excel Discussion (Misc queries) 2 February 25th 05 02:33 PM
Customizing a worksheet size ElainePhd Excel Worksheet Functions 1 February 9th 05 03:01 AM
Increase default size of worksheet Westontony New Users to Excel 9 December 17th 04 12:03 AM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 02:42 AM


All times are GMT +1. The time now is 10:06 AM.

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"