Custom Icons...

**garethgtt** · 02-27-2007, 06:04 AM

Hi,

I have tied a macro into a custom icon i have created in the standard toolbar--- however this icon isnt saved with the workbook, its saved as part of excel.. problem is i want this icon to be attached to this workbook rather than just my excel.

how can i do this?

**davesexcel** · 02-27-2007, 07:10 AM

Hi,

here's something to test out

open a new workbook

press alt-f11
select insert from the menu, insert module

copy and paste this code there

Please Login or Register  to view this content.

in the workbook Module
At the top of the screen next to the word file there should be an XL icon

right click on the icon and select view code, now you are in the workbook module,
Paste this code into that module

Please Login or Register  to view this content.

save the workbook and exit
open the workbook again and your custom toolbar show up, open another workbook the new workbook should not have the toolbar, return to the first workbook and the toolbar should be there, when you close the workbook the toolbar will be deleted.