Limit workbook size

R

R D S

Hi,
Can someone please remind me how to limit the size of a sheet?
I dont need anything past V:30

Thanks,
Rick
 
D

Dave Peterson

Maybe just hiding columns W:IV and rows 31:65536.

They're always going to exist, though.
 
W

William

Hi

Try entering this code in the "ThisWorkbook" module.

Private Sub Workbook_Open()
With Sheets("Sheet1")
..scrollarea = ""
..scrollarea = "A1:V30"
End With
End Sub

--


XL2003
Regards

William
[email protected]
 
Top