Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programically remove code from a worksheet
I have a workbook that I need to copy a particular sheet out to save in a
separate workbook. This part is done and works. The worksheet has an Activate piece that shows a user form. When I copy the worksheet into its own workbook, programically, the code comes with it. When the sheet is activated in the new workbook the code erros out because the user form is not copied over with it, the userform is not needed in the new workbook. How can I programically removed the Worksheet_Activate code when the worksheet is programically copied out? Thanks for any help -- Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
programically refresh pivot chart formatting | Excel Programming | |||
Problem with Updating Add-in path programically | Excel Programming | |||
Remove VBA code behind a worksheet | Excel Programming | |||
How do you programically remove carriage returns within a cell | Excel Programming | |||
remove code from behind worksheet | Excel Programming |