How to hide/show row/column headers and sheet tabs.
Hi,
I know how to goto Tools/Options/View to change whether
or not a worksheet displays Row&Column headers, Sheet
tabs, and the Horizontal & Vertical scroll bars, but can
I set these attributes differently for different
worksheets?
Seemingly not in Tools/Options as the result appears
random, ie in worksheet 1, (for instance), if I hide the
row/column headers they are not hidden in worksheets 2
and 3 etc, although if I hide sheet tabs in one
worksheet, they are hidden in all.
I use macros to navigate to different worksheets, and I
need to set or unset these attributes differently,
depending which worksheet is being visited.
If there is a way I assume it will be VBA, but what would
the code be?
Many thanks
Mark Flaxman
|