Using vb macro to delete a Command Button and it's code in Excel

SAH

This code:-

Gets rid of the Button OK but it leaves the Code in the Command Buttton1_Click Subroutine and I should like to clear that too.
Can I do that in the vb macro?

Nov 21 '06 #1

SAH

I still need help with this please.

Nov 23 '06 #2

albertw

I still need help with this please.

hi

don't think you can change the macro in run-time
guess you're stuck here.

Nov 23 '06 #3

SAH

OK. Thanks anyway.
I guess it is not a big deal but if the macro security is on then when you open the sheet, the deleted button appears until you accept or decline the macro function. Then it disappears. Not vital but it is a bit untidy!

Thanks again,
Simon

Nov 23 '06 #4