Copy Add-In Worksheet to Client Worksheet EXCLUDING VBA Code

[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)

 

[Tom Ogilvy]

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.