Eric Hearn
New Member
- Joined
- Mar 17, 2006
- Messages
- 42
I have a workbook sheet containing 5 command buttons, one of which copies the sheet to a new workbook (say Book2) in which it then converts all formulas to values, removes all data validation and deletes the 5 command buttons. However the code which was attached to those buttons remains and gives rise to a macro security warning whenever Book2 is re-opened.
Can I modify the button's macro to also delete all 5 CommandButtonx_Click() macros from Book2?
T.I.A.
Eric Hearn
Can I modify the button's macro to also delete all 5 CommandButtonx_Click() macros from Book2?
T.I.A.
Eric Hearn