Thread: possible to save macro with workbook as add-in?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith John Smith is offline
external usenet poster
  
Posts: 62
Default possible to save macro with workbook as add-in?
I finished writing a macro. It works well. When I save the macro
as an add-in and then open the add-in, it doesn't work. It
complains about codes like sheet1.Cells(1,2).select. Seems the
workbook was not saved along with the macro.

Is it possible to save the workbook with macro as an add-in?
Reply With QuoteReply With Quote