Thread: Reduce sheet size
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Joshua Fandango Joshua Fandango is offline
Member
  
Location: In a hole in the ground there lived Joshua Fandango
Posts: 30
Default 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.

Reply With QuoteReply With Quote