View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] alexbarham@yahoo.ca is offline
external usenet poster
 
Posts: 4
Default Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Curre

Yes. CleanSheet is spelled correctly, I checked several times as I've
racked my brain on several occasions over something that turned out to
be spelling. As for how the module was developed, I created it in a
Workbook and I saved the workbook as an xla file. I didn't actually do
it in a module. I did try creating the menu and the procedure in a
workbook and used .OnAction = "ThisWorkbook.CleanSheet" And it worked.

Should I have originally coded this in a module?