.onaction macro call won't work
Yes it was. Put it in a standard code module and re-assign the macros to the
buttons.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Wayne" wrote in message
...
I did put it in th4 ThisWorkbook module. I don't have a
clear understanding yet of what goes where! Obviously...
So that was a mistake? :-)
Wayne
-----Original Message-----
Are you sure that you put your macros in a standard code
module, not one of
the calls modules such as ThisWorkbook, or the sheet
modules?
--
HTH
RP
(remove nothere from the email address if mailing direct)
wrote in message
...
Sorry for the crosspost, put it in the wrong forum.
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
.
|