Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the Toolbar Invisible through VBA
Hi,
I Wanna make some Toolbars invisible as User starts using my exce sheet. I also want to make tab sheet invisible. Can anyone help me out of this Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the Toolbar Invisible through VBA
Hi Atif,
You can uese macro recorder. Here is a code generated by macro recorder. Code ------------------- Sub Macro1() ' ' Macro1 Macro 'Recorded : 2003/12/11 User : Colo the VBA Guy ' ' Application.CommandBars("Formatting").Visible = False Application.CommandBars("Control Toolbox").Visible = False Application.CommandBars("Standard").Visible = False ActiveWindow.DisplayWorkbookTabs = False End Sub ------------------- -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the Toolbar Invisible through VBA
One word of warning:
The *hidden* toolbars will still be hidden when the user opens a different workbook. Most users like to have their *favorite* toolbars visible by default and would be irritated to have to *rebuild* their preferred set. To remedy this, you should return to visibility all items you have hidden. Do this in the Workbook_Close event. You may also hide all toolbars with Application.DisplayFullScreen=True Then reverse this as you close the wbk (Workbook_Close event). --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a chart axis visible/invisible with VBA | Charts and Charting in Excel | |||
make button invisible if macros disabled | Excel Discussion (Misc queries) | |||
How to make hidden sheet invisible | New Users to Excel | |||
Code to make graph invisible / invisisble | Excel Programming | |||
Make one column Invisible. | Excel Programming |