hiding row and column headings

  • Thread starter Thread starter sixfivebeastman
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Macro to hide colums with value of zero or blank 3
Sum Columns with Specific Headings 6
Hide Row and Column Headings 3
Help with printing rows and/or columns 1
hiding the column and row heading 1
Hiding rows where text not entered to right of colums A and B 1
Pivot table - filtering out rows that have blank columns 1

Back
Top