Limit workbook size

[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

 

[Dave Peterson]

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

They're always going to exist, though.

 

[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
(e-mail address removed)