Create Toolbar Button

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I want to create a couple of buttons to place on my toolbar. Some to open
commonly used files and one to load a template. Any links/pointers
appreciated.

Thanks
 
Found a much, much easier way. Just right-click toolbars>Customise>Macros.
Drag and drop a custom button then modify selection and assign a hyperlink.
Much easier for those of us that don't do VBA very well!!!

Thanks anyway though,
A
 
Just for info.

These customizations are saved in your Excelxx.xlb file.

Many such customizations will increase the size of the file.

This file has a tendency to become corrupt when it gets too large and will
give you problems.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toolbar buttons to hide/unhide sheets 8
How to remove customized button from toolbar? 1
Move Macro Button on Sheet to a toolbar 3
Assigning Macros in Excel 2007 1
Toolbar - Button Won't Stay 3
Show Custom Toolbar on open 2
Excel 2003 Custom toolbar problem saving new buttons 6
custom toolbar item to use hyperlink to open word file 2

Back
Top