Hide Macro Button

[Doogs2009]

Hi
Is there some simple code I can write to add to some VBA, that will hide a macro button after its been activated so it does not show in the worksheet. Then upon opening that workbook again at a later date, the macro button will be visible. So I guess I am after some code for Hide, then Reveal on opening!!!
Thanks guys
Craig

 

[meldoc]

Hello

Try this, put a forms button named Button 1, on sheet1 change suit your needs.

Standed module

Sub test()
  'your code
  Sheet1.Shapes("Button 1").Visible = msoFalse
End Sub

Thisworkbook module

Private Sub Workbook_Open()
  Sheet1.Shapes("Button 1").Visible = msoTrue
End Sub

 

[OfficeUser]

You could also hide it using this in your macro it intializes:

YourButtonNameHere.Visible = False

This will work even if you copy the sheet using a different name.

 

[Doogs2009]

Thanks everyone, both these suggestions worked. Cheers and thanks for your help.
Craig