Hide 'excess' cells

G

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
 
F

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
 
N

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
Click to expand...

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