hiding row and column headings

S

sixfivebeastman

Hello, could anyone tell me how to hide the row and column headings (A
B, C, D...etc.) using VBA? I've got the fullscreen mode running wher
all the toolbars are hidden, but I can't get rid of the row/colum
headings.
Thanks!
Ti
 
T

Tom Ogilvy

Turn on the macro recorder, then do Tools=>Options=> View,

unselect Row and Column Headers.

Turn off the macro recorder and see what was recorded. This should be the
code you need.

ActiveWindow.DisplayHeadings = False
 
Top