Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding a column of hyperlinks behind a column of numbers cmiling New Users to Excel 2 November 20th 09 05:02 PM
hiding an error value, using INDEX/MATCH mariekek5 Excel Discussion (Misc queries) 3 June 18th 09 01:25 PM
Hiding Column Also hiding text Cindy Excel Programming 0 April 6th 06 07:18 PM
Need help hiding/unhiding column based on autofilter selection in a different column kcleere Excel Programming 1 January 23rd 06 06:21 AM
Hiding worksheet row and column identifiers salliesatt Excel Discussion (Misc queries) 1 February 13th 05 06:47 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"