Copy Add-In Worksheet to Client Worksheet EXCLUDING VBA Code

  • Thread starter Thread starter Mark D'Agosta
  • Start date Start date
M

Mark D'Agosta

All,

I've created an Add-In that populates worksheets within the Add-In then
copies the worksheet to the client workbook for user viewing (using a simple
Copy method). However, there is VBA code within the Add-In worksheet that
I'd prefer that did not get copied to the client side. What is the best
way to do this?

Thanks,
Mark D'Agosta
(e-mail address removed)
 
put a worksheet in the addin that doesn't have code in it. Write you data to
that.

or
rather than copy the sheet, add a new sheet in the workbook, copy the cells
of the sheet in the addin and paste into the new sheet.
 
Back
Top