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
SAH
Last Activity: Nov 27 '06, 09:19 AM
Joined: Nov 21 '06
Location:
-
I still need help with this please.Leave a comment:
-
SAH started a topic Using vb macro to delete a Command Button and it's code in Excelin Visual BasicUsing vb macro to delete a Command Button and it's code in Excel
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.Code:ActiveSheet.Shapes("CommandButton1").Delete
Can I do that in the vb macro?
No activity results to display
Leave a comment: