Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a workbook to hold all my favorite macros. I have created a
macro that builds a custom toobar assigning a button to each of my macros. I have created custom Faces to use on each button, and use the PasteFace method to load the image onto the button. The images are stored on one of the worksheets in the file as objects, e.g "Picture 2". These images were created by customizing a toolbar button and then copying the image to the worksheet. The custom toolbar is created on the opening of the file and is deleted on the closing of the file. All this works perfectly. Howerver, I would like to figure out how to save this as an Add-In file so that I can share it with others. When I save it as a XLA file, everything works flawlessly EXCEPT the button images are not showing in the toolbar. If I use one of the default Face-Ids (using the ..FaceId = # instead of the PasteFace), then the button shows the image. I am storing the Drawing Objects on a worksheet and I know that when I create the XLA, that Worksheet goes away. So where can I store Drawing Objects so that the XLA can find them? I know that there are a few thousand button images to choose from, but I just want to see if this would work. Thanks, Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Group drawing objects in VBA | Excel Discussion (Misc queries) | |||
Cutting Drawing Objects | Excel Discussion (Misc queries) | |||
HOW DO I KEEP DRAWING OBJECTS ANCHORED? | Excel Discussion (Misc queries) | |||
Storing generic objects in workbook via automation | Excel Programming | |||
[Q] parameters to drawing objects | Excel Programming |