Custom Toolbar

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Ok boys & girls...

Have been looking around on the topic of toolbars hiding/unhiding etc which is great. And I know I have seen something on custome toolbars etc... but I was hoping someone could give me a succint answer to this aim:

I want to hide all toolbars on the basis of NT user Login (all done).

I want to create a custom toolbar that has just one button it - called "Close" - and that closes the file - I have an AUTO_CLOSE macro set up to run various codes so I am not concerned with saving changes etc...

Can anyone help?

I will be putting this into an AUTO_OPEN Macro hopefully (just in case that affects anything).

Waiting patiently on your learned responses...

Thanks
LASW10 (Luke)
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Have found how to do this...

Have created a toolbar and then attached it to the file so it uploads on anyone's PC that opens it - whilst then deleting itself in the Auto_Close Macro.
 

Forum statistics

Threads
1,144,117
Messages
5,722,581
Members
422,447
Latest member
knopp

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