ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hiding the column and row heading (https://www.excelbanter.com/excel-programming/334983-hiding-column-row-heading.html)

krhyme[_2_]

hiding the column and row heading
 

How do I hide the column and row heading in a excel worksheet??

(I dont want to see A B C D at the the and 1 2 3 4 at the left)

thanks

--
krhym
-----------------------------------------------------------------------
krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=38850


jjk

hiding the column and row heading
 
ActiveWindow.DisplayHeadings = False

and few others

ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayGridlines = False

Regards,
Jayant



All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com