View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default hiding row and column headings

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


--
Regards,
Tom Ogilvy


"sixfivebeastman " wrote in
message ...
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 where
all the toolbars are hidden, but I can't get rid of the row/column
headings.
Thanks!
Tim


---
Message posted from http://www.ExcelForum.com/