Hide 'excess' cells

[GerryK]

Hi,
How can I Hide all cells other than A1:Z35, properly.
(I do not want the Row or Column headers visible outside
of that range.)
My first attempt caused the workbook to not open all the
way.
TIA

 

[Frank Kabel]

Hi
you may use the following macro for this
sub hide_it
columns("AA:IV").hidden=true
rows("36:65536").hidden=true
end sub

 

[NewsGroups]

Hi
you may use the following macro for this
sub hide_it
columns("AA:IV").hidden=true
rows("36:65536").hidden=true
end sub

.... or just use Format/Column/Hide; Format/Row/Hide