View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default 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