Custom Toolbar

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,124
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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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.
 
Upvote 0

Forum statistics

Threads
1,214,523
Messages
6,120,028
Members
448,940
Latest member
mdusw

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
Back
Top