Hiding Row and Column Index in a Worksheet
 

Dear All,
I am making a Program in Excel with VBA.
I just want to hide the Row and Column Index of all the sheets.
I searched for proper codings in F1 but in vain.
Please suggest me whether there is any function available for hiding the Row
and Column Index of sheet.
Thanks and Regards,
Premanand Sethuraman

Hiding Row and Column Index in a Worksheet
 

You mean column header & row header?
it can be removed from "Tools-Options-View(tab)-Row& column headers
(check-list)".

*** please do rate ***





"Premanand" wrote:

Dear All,
I am making a Program in Excel with VBA.
I just want to hide the Row and Column Index of all the sheets.
I searched for proper codings in F1 but in vain.
Please suggest me whether there is any function available for hiding the Row
and Column Index of sheet.
Thanks and Regards,
Premanand Sethuraman

Hiding Row and Column Index in a Worksheet
 

Thanks Naveen,
I am doing VB codings in Excel. But So far I do not know about it.
It is clearly showing how lagging I am.
Thank you very much
Regards,
Premanand.S

"Naveen" wrote:

You mean column header & row header?
it can be removed from "Tools-Options-View(tab)-Row& column headers
(check-list)".

*** please do rate ***





"Premanand" wrote:

Dear All,
I am making a Program in Excel with VBA.
I just want to hide the Row and Column Index of all the sheets.
I searched for proper codings in F1 but in vain.
Please suggest me whether there is any function available for hiding the Row
and Column Index of sheet.
Thanks and Regards,
Premanand Sethuraman