View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anna B Anna B is offline
external usenet poster
 
Posts: 10
Default Hiding row and column headers, scroll bars

When my command button takes me to my sheet, I want the sheet not to show any
row or column headers or scroll bars. I tried just going to the sheet and
unchecking the boxes under tools, but they come right back again when I leave
the sheet then return to it.

Is there a way to put code somewhere that tells those to be hidden when a
sheet is selected? Thanks