Saving and restoring toolbar settings

FreddyKrueger · Jun 22nd 2005

Hi all

I have a program that runs using VBA Excel forms. Everytime the user opens the program I want all the toolbars to be removed and when he exits I want the toolbar options to reset to what it was before the program was opened. Currently I am assigning variables individually to each toolbar option as True of False depending on whether it is visible when the program opens, using this to restore the default settings when the user exits. But this process seems long and inefficient. There must be a quicker way to capture current toolbar selections??!!

Dave Hawley · Jun 22nd 2005

Re: Saving and restoring toolbar settings

Hi Freddy

Try some code like shown below, it's quick and puts the onus on Excel to retore as it was

Code

Sub HideThem()


     With Application
        .DisplayFullScreen = True
        .CommandBars("Full Screen").Visible = False
        .CommandBars("Worksheet Menu Bar").Enabled = False
     End With
End Sub
Sub ShowThem()


     With Application
        .DisplayFullScreen = False
        .CommandBars("Worksheet Menu Bar").Enabled = True
     End With
End Sub

Display More

FreddyKrueger · Jun 22nd 2005

Re: Saving and restoring toolbar settings

Thanx. This partly help. But it only removes the menu bar. It leaves all the selected toolbar options visible. I want to set there visibility to "false" aswell so that no toolbar selections are visible.

Dave Hawley · Jun 22nd 2005

Re: Saving and restoring toolbar settings

No, it hides the whole lot, including the Worksheet Menu Bar so users cannot set them back to visible.

Saving and restoring toolbar settings

Participate now!

Share