try this link
http://www.ozgrid.com/VBA/delete-sheet-code.htm
On Fri, Jun 27, 2014 at 3:03 AM, Rob Flott wrote:
> My application allows the user to make a copy of a worksheet so it can be
> viewed outside of the application. The problem I have with this is the
> code written to that specific
ohn Wesley
-
From: Rob Flott
>To: excel-macros@googlegroups.com
>Sent: Thursday, June 26, 2014 5:33 PM
>Subject: $$Excel-Macros$$ How to remove vb code after you make a copy
>
>
>
>My application allows the user to make a copy of a worksheet so it
My application allows the user to make a copy of a worksheet so it can be
viewed outside of the application. The problem I have with this is the
code written to that specific worksheet.
Is there code I can include in the 'make copy' macro that would remove all
VB code associated to that sheet
