Disabling row and column headers option
Dave,
What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).
Can you tell me how to disable the "Row and column headers" checkbox in VBA?
Thanks,
Bob
"Dave Peterson" wrote:
I don't think you can change any of those built-in dialogs.
You can disable them, but you can't change them.
Bob wrote:
Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.
Thanks in advance for any guidance.
--
Dave Peterson
|