Hide column and row labels

[flavioso]

I would like to know if there is a way in vba to hide the actual labels for the columns, i.e. A, B, C D, 471,472,473.

I want the user to be able to see the rows, just not the label.

Any suggestions? Yes, I know you can hide it in the settings, but I plan on modifying what menus/ribbon they are able to see.

Thanks

Brad

 

[MrKowz]

I got this from recording a macro and hiding labels:

ActiveWindow.DisplayHeadings = False

 

[flavioso]

Thank you. I looked at that and couldn't make my mind up. Thanks again for your help!