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