| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding row and column headings
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 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hiding row and column headings
This should do it.
ActiveWindow.DisplayHeadings = False -----Original 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/ . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Hiding Column Headings (A,B,C,...) and Row Names (1,2,3,.. | Excel Discussion (Misc queries) | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
![sixfivebeastman[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
