Hide 'excess' cells

  • Thread starter Thread starter GerryK
  • Start date Start date
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
 
Hi
you may use the following macro for this
sub hide_it
columns("AA:IV").hidden=true
rows("36:65536").hidden=true
end sub
 
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
 
Back
Top