Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What I want:
- create a custom toolbar with some buttons, attach macros to the buttons and save the whole thing in an .xls file. - to be able to use the file with my program (does excel automation), i.e. programmatically open the file and display the toolbar, but only when I say so. What happens: I open a file, create a toolbar, buttons, macros and save the file, e.g. Toolbars.xls, close Excel. Then whenever I open Excel with ANY file, the darned thing appears. Attach or no attach - doesn't matter. When I copy Toolbars.xls to another machine and open it, the toolbar appears but w/o any buttons. After that this empty toolbar appears when I open ANY file on that machine. This behaviour is nonsensical and counterintuitive. I did a similar thing with Word and it all worked as expected, i.e. I saved macros and buttons a Toolbars.doc file, then opened it whenever I wanted and attached it to whichever doc file I wanted on any computer. And it didn't just show up on its own. The help file is of no help. It's Excel 2000/97, but I'll need it with any Excel 97+ Please help! Thanks ---- Igor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On custom toolbar, how to save macro link to flashdrive ? | Excel Discussion (Misc queries) | |||
Save Macro and Custom Toolbar in Worksheet | Excel Discussion (Misc queries) | |||
Show Custom Toolbar on open | Excel Discussion (Misc queries) | |||
How do I save a custom toolbar? | Excel Discussion (Misc queries) | |||
Cannot Get Caption to show on custom toolbar button | Excel Programming |