Friends,
How do I hide and unhide sheet names programmatically? Any clue?
Regards,
Gajendra Gupta
Hi,
Sheets("Sheet name").Visible = True Sheets("Sheet name").Visible = False
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
No, it doesn help me. it just visibles the sheets. I want sheet tabs to hided or visible.
Regards,
Gajendra Gupta
No you cannot selectively hide tab for a sheet. You can however hide all tabs byOriginally Posted by gajendra.gupta
Other work around could be to rename the sheet to " " and then back to the original name. Tricky if you are using the sheet names in your prog. If you use only indexes eg sheet(1) etc this workaround might do. code could beActiveWindow.DisplayWorkbookTabs = False
This will ofcourse not hide the tabs but the name will be blanked out.Sheets(1).Name = " " ' becomes invisible Sheets(1).Name = "OldName" ' becomes visible
A V Veerkar
Last edited by avveerkar; 05-21-2007 at 06:43 AM.
This will toggle Tabs on and off
ActiveWindow.DisplayWorkbookTabs = Not_ ActiveWindow.DisplayWorkbookTabs
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks