View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default .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



.