Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Button OnAction property...
Thanks a lot for your answer, Dave...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
Need Help with a Menu Item .OnAction property | Excel Programming | |||
Button Selection OnAction property | Excel Programming | |||
Find OnAction property | Excel Programming |