View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Add Sub to Button Bar

If you put your images in a worksheet (hidden???), you can copy and paste.

Try googling with the *excel* newsgroups for .pasteface
and you'll see lots of samples.

Stanley wrote:

Yes I created a workbook called myaddins.xls and was hoping to be able to
pull them from that workbook into excel with custom images hopefully.

"Dave Peterson" wrote:

Are all your Sub's in the same workbook?

If yes, then maybe you could use this:
http://contextures.com/xlToolbar02.html
from Debra Dalgleish's site.

Stanley wrote:

Is it possible to add a button to the bar at the top and have it run a SUB I
wrote? I have several SUBs that I have to run on many different spreadsheets
and I get tired of having to attach the module and then run it. It would be
so much easier if I could add a button like Adobe does.


--

Dave Peterson


--

Dave Peterson