Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
Can a sheets size be reduced from 65000 rows to 1000 rows? Not just
hidden. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
No.
What's wrong with hidden? -- Kind regards, Niek Otten Microsoft MVP - Excel "Fan924" wrote in message ... Can a sheets size be reduced from 65000 rows to 1000 rows? Not just hidden. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
You could use:
Sub Limit_Rows() Sheets("Sheet1").ScrollArea = "A1:Z1000" End Sub To limit the area users can access HtH JF On 10 Mar, 14:50, Fan924 wrote: Can a sheets size be reduced from 65000 rows to 1000 rows? Not just hidden. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
Hi
A sheet has 256 columns and 65536 rows - regardless. By Hidden, I take it your are referring to Hiding the whole sheet. You can hide rows 1001 to 655536 to just show the first 1000 rows. Similarly, you can select any range of columns and hide them. Alternatively, you can set the Scroll area of the sheet to any range you wish, and that will prevent the user from scrolling or accessing any cells outside of that range. To set the scroll area, you would need to do that programmatically. Private Sub Worksheet_Activate() ScrollArea = "A1:H20" End Sub Set the area to whatever you want Copy the Code above Right click Sheet tab View Code Paste code into white pane that appears Alt+F11 to return to Excel This is event code which will be triggered automatically. -- Regards Roger Govier "Fan924" wrote in message ... Can a sheets size be reduced from 65000 rows to 1000 rows? Not just hidden. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
"Fan924" wrote in message ... Can a sheets size be reduced from 65000 rows to 1000 rows? Not just hidden. You could also merge all the cells from 1001 to the bottom and across to last column into one large cell. Not sure what you are try to accomplish Mike |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce sheet size
"vMike" wrote in message ... "Fan924" wrote in message ... Can a sheets size be reduced from 65000 rows to 1000 rows? Not just hidden. You could also merge all the cells from 1001 to the bottom and across to last column into one large cell. Not sure what you are try to accomplish Mike I should add that you would also want to set its row height to say .1 or something small. I think that will accomplish what you what Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help to reduce size of my file | Excel Discussion (Misc queries) | |||
Externalising a sheet to reduce Workbook size | New Users to Excel | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
reduce the size of a file | Excel Discussion (Misc queries) | |||
How can I reduce the Size? | Excel Programming |