Copy Add-In Worksheet to Client Worksheet EXCLUDING VBA Code


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

Advertisements

T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top