.ONACTION macro call fails

W

Wayne

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
 
D

David McRitchie

One of the advantages of John's addin is the ability to arrange
your menus within submenus. So I think a better example for
doing it yourself should show that as well. I used to use John's
add-in until I got a better idea of what I wanted in my menus then
just created the menus manually and turned off the addin and the
overhead.

I do have a page to document what is in my toolbar menus,
and shows an example of what I have in mine.
I never did finish with the opposite, which would be to create the menus
which would have been useful for sharing menus.
Barhopper -- fixup for Restored Toolbars, and -- Listing of Menu Items
http://www.mvps.org/dmcritchie/excel/barhopper.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top