Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I created a custom toolbar first without code and
attached macros to the buttons, and they worked fine. however, I had problems sharing the workbook with others; I followed some code posted here to create a toolbar in code, I used the .onaction property to assign the buttons to the same macros but they don't work - it says macro doesn't exist!! I noticed this difference - when it fails it says the macro "filename.xls!macroname" not found. But when I use the toolbar customize fature to assign the macro it's in the form "Thisworkbook!macroname". Looking for help!! Wayne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) |