How to hide row/column labels from VBA?

[ilia]

Hi everyone,

I've been looking around for this and experimenting with a few
techniques, but I cannot find the explicit answer to this one.

I want to hide the row/column labels in my dictator-style Excel 2003
application, using VBA. So, here are some questions, please let me
know if you know the answers:
* Are these part of CommandBars collection?
* If so, is there a systematic method for identifying them?
* Are there any application-wide restrictions that would cause
run-time errors, if one were to change their Enabled and/or Visible
setting?

Thanks in advance for any advice,

-Ilia

 

[Jim Cone]

Ilia,

This toggles the row/column display on and off...
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings

You cannot hide individual column or row headings.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"ilia" <[email protected]>
wrote in message
Hi everyone,
I've been looking around for this and experimenting with a few
techniques, but I cannot find the explicit answer to this one.
I want to hide the row/column labels in my dictator-style Excel 2003
application, using VBA. So, here are some questions, please let me
know if you know the answers:
* Are these part of CommandBars collection?
* If so, is there a systematic method for identifying them?
* Are there any application-wide restrictions that would cause
run-time errors, if one were to change their Enabled and/or Visible
setting?
Thanks in advance for any advice,
-Ilia

 

[ilia]

This is exactly what I was looking for. Thank you for your help.

-Ilia


"Jim Cone пиÑал(а):
"