View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Make a button disappear

Try this

ActiveSheet.Shapes("yourbutton").Visible = False

Or

ActiveSheet.Shapes("yourbutton").Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Aaron Howe" wrote in message ...
Is there a specific piece of code to remove a form/control button from a
worksheet? Have tried many things, none of them working! I don't mind if
it's just hidden actually, so long as it can't be seen by the end user once
the code has run its course