Hide Column Letters and Row Numbers in VBA

[Patrick A]

Does anyone know if you can hide the Column Letters and Row Numbers
using VBA?

If so, what's the syntax? I can't seem to find anything on it.

Thanks

 

[Dave Peterson]

If you record a macro when you do it manually, you should get the syntax.

 

[Patrick A]

Dave,

Thanks very much!

Wow, you can find out all sorts of stuff that way!

With ActiveWindow
.DisplayGridlines = True
.DisplayHeadings = True
.DisplayWorkbookTabs = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
End With