Toolbar help...

  • Thread starter Thread starter mjack003
  • Start date Start date
M

mjack003

Hi,

I have a command button which I need to access from every worksheet in
a workbook. How would I go about putting this command button into a
toolbar so it will be seen at all times?
Any help is appreciated.

Best Regards,
Mjack
 
Mjack,
Is the command button calling a macro? If so you can add a button to a toolbar and assign the macro to it.

1) Right click on an existing toolbar and select Customize.

2) If desired, select New to creat a new toolbar

3) Select Commands and go to Catagory Macros

4) Drag the Custom Button to the desired toolbar

5) With the Customize dialog box still open, right click on the new button

6) Now you have multiple option:

Name: creates custom pop-up text when you hover over the button.
Button Image: allows you to modify the image
Assign Macro: allows you to designate a macro for that button.

Good Luck,
Mark Graesser
(e-mail address removed)

----- mjack003 > wrote: -----

Hi,

I have a command button which I need to access from every worksheet in
a workbook. How would I go about putting this command button into a
toolbar so it will be seen at all times?
Any help is appreciated.

Best Regards,
Mjack
 
Right click on the toolbar and select "customize"

Then drag the button that you want onto your toolbar.
 
Back
Top