Problem with Button OnAction property...
 

Sorry... But I have always the same problem...

The error is: Impossible locate MyExcelSheet.xla!MySub

MyExcelSheet.xla is located in C:\Documents and
Settings\UserName\DatiApplicazioni\Microsoft\AddIn s and it contains codes
for adding a custom button to Excel application. After setting OnAction
property with a value < "ThisWorkbook.FullName" & MySub as suggested me
from the good Bernie, the error appears!!

Someone help me???

Sorry for my english but I'm very hopeless....

Problem with Button OnAction property...
 

Your reply was separated from the original thread (at least for me).

But you may find it much easier to build the toolbar on the fly when the
workbook opens and destroy the toolbar when the workbook closes.

John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

If you want a toolbar, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

fausto wrote:

Sorry... But I have always the same problem...

The error is: Impossible locate MyExcelSheet.xla!MySub

MyExcelSheet.xla is located in C:\Documents and
Settings\UserName\DatiApplicazioni\Microsoft\AddIn s and it contains codes
for adding a custom button to Excel application. After setting OnAction
property with a value < "ThisWorkbook.FullName" & MySub as suggested me
from the good Bernie, the error appears!!

Someone help me???

Sorry for my english but I'm very hopeless....

--

Dave Peterson

Problem with Button OnAction property...
 

Thanks a lot for your answer, Dave...