Hide Toolbars

LoopCost

New Member
Joined
Sep 8, 2002
Messages
8
How would I go about hiding the default toolbars?? I am going to create custom toolbars but I do not want to give the user the option to use the defaults.

TIA

RR
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

wob

Board Regular
Joined
May 21, 2002
Messages
105
i'm pretty sure you can only do this if all users share the same personal.xls file (on a network).

i could be wrong....

is this ok?
 

LoopCost

New Member
Joined
Sep 8, 2002
Messages
8
Having the same personal.xls is NOT an option. Does anyone have any other ideas???
 

wob

Board Regular
Joined
May 21, 2002
Messages
105
getting a bit more background...

a user can always change their toolbar settings. you can't make any changes permanent without resorting to forcing them behind a macro.

as far as i know anyway.

i suppose that you could reset the toolbars for each user's pc to start them off, but i don't think you can keep those settings permanent.
 

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053

ADVERTISEMENT

How many custom icons are you going to give them? One possibility is, instead of tool in a toolbar, create macros and assign them to buttons. Then, use View/Full Screen to hide the default tool bars. Of course, there's no way to prevent the user from going and turning off Full Screen. Never mind.
 

LoopCost

New Member
Joined
Sep 8, 2002
Messages
8
More backgroud:

This would only be nessisary when a specific *.xls file is opened and that file would have to contain the VBA code to hide the toolbars. I would really like to avoid the full screen option as it would remove my custom toolbar. :)

Keep the ideas comming! You all are great.

RR
 

Mav

New Member
Joined
Mar 23, 2002
Messages
18
this macro will hide the default toolbar:

Sub notools()
'
' notools Macro
'
'
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Visual Basic").Visible = False
End Sub
 

Mav

New Member
Joined
Mar 23, 2002
Messages
18
probably just the first line in the macro above is the one needed if you "unselect" all others at default....anyways, this is what I use to restore the tool bars after hiding them:

Sub toolson()
'
' notools Macro
' Macro recorded 5/7/2002 by Randy
'
Application.CommandBars("Standard").Visible = True
Application.CommandBars("Formatting").Visible = True
Application.CommandBars("Visual Basic").Visible = True
End Sub
 

Forum statistics

Threads
1,144,734
Messages
5,725,983
Members
422,652
Latest member
Elnene1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top