Thread: Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb
View Single Post
  #3   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 Current Wkb
I tried .OnAction = ThisWorkbook.Name & "!CleanSheet"
and I received the error message "The macro 'ClearSheet.xla!CleanSheet'
cannot be found".

Reply With QuoteReply With Quote