Hiding Row and Column Index in a Worksheet

P

Premanand

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
 
N

Naveen

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

*** please do rate ***
 
P

Premanand Sethuraman

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
 

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

Insert Index into a Table 1
hiding blank rows 3
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
hidden rows, column copy-paste 0
Setting Scroll Area 1
Auto Copy Data from one worksheet to another 1
Help with Index formula 2
Run macro on all files in a specific folder 3

Top