[SOLVED] Moving Toolbar and Macros To Other Computers

[amyxkatexx]

So, I have made a custom toolbar with 40 custom buttons that link to 40 separate macros that are saved into a hidden workbook that starts whenever excel opens.

I would love to be able to share my toolbar with others, so I know that I would need to send my workbook to the individual and then save it into their startup folder just the same as I have done to mine. The problem is...it took a lot of time to assign each and every one of those macros to custom buttons and change the icon on each one. Is there any way that the toolbar can be transferred along with the sheet so that they are still linked?

I know this is probably a shot in the dark, but it would be really awesome if anyone knew how to do this, or even something like it.

Thanks in advance.

-Amy Kate

[teylyn]

have a read through this: http://office.microsoft.com/en-au/ex...721011033.aspx

[romperstomper]

Bear in mind that any toolbar buttons you have created will expect the workbook with the code in to be in a specific place. If you have used the XLSTART folder under C:\program files\microsoft office\office then that should be fine for another user. If, on the other hand, you have it in your own personal XLSTART folder (which will be within your user documents path) then the toolbars won't work immediately for other people just by copying the xlb file.
This is why developers tend to build their toolbars in code when the code workbook opens rather than trying to distribute xlb files or trying to attach toolbars to a workbook.

[royUK]

You need to convert the workbook to an addin

[amyxkatexx]

have a read through this: http://office.microsoft.com/en-au/ex...721011033.aspx

That site is great and all, and I think that is definitely the answer, but the problem is that it doesn't explain how you can use image buttons. My buttons are only images and the text is turned off. I tried my googling skills but was unable to find another site with any information on this. Do you know what to do?

You need to convert the workbook to an addin

Are you saying that I can convert the workbook without using the code that teylyn linked to? If so, how?

[amyxkatexx]

Well, I haven't gotten any responses in a while, so I'm hoping that maybe someone else might be able to answer my last question about the code used to include images for the icons on a macro button.

Any ideas or websites you guys can find would be great because I can't find anything.

Thanks.

[romperstomper]

If you have the images saved as files, you can use code like:

Please Login or Register  to view this content.

[amyxkatexx]

Is (strPicFile) the name of the picture? Does it not need a .jpg or .gif at the end? Also, where do the pictures need to be in relation to the spreadsheet for it to access them? Also, if I have a folder that is full of these images, how would I tell it to access it within that folder.

If you got that code from a website that has other information, could you just send me the link because I can't find any specifics about how to use this code anywhere. That way I won't have to keep bugging you with questions.

Thanks so much though, this definitely is what I was looking for...just now I have to figure it all out.

:]

[romperstomper]

That's my code, so I can't point you anywhere else!
In order to call that routine you need other code like this:

Please Login or Register  to view this content.

You specify the filepath and the control you want to put the picture on when you call the first sub I posted.

[amyxkatexx]

Would there be any flaw in simply attaching the toolbars to the sheet that has the macros running on it and place that in their startup file and hide it?

[romperstomper]

Not really, as long as you don't plan to update it. (the toolbar will be copied onto the target machine the first time the workbook is opened on it.)

[amyxkatexx]

Thanks, that more suits my needs as I don't see any reason I would ever need to update this particular macro.

I may look into that in the future if I am ever working on more complicated macro toolbars.