Thread: errrors while trying to delete a commandbutton
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
funkymonkUK[_195_] funkymonkUK[_195_] is offline
external usenet poster
  
Posts: 1
Default errrors while trying to delete a commandbutton

hi

I have a commandbutton placed on a sheet call "Information" the
Commandbuttons Name is Updater.

i have the following piece of code

Private Sub updater_Click()
Range("a1").Activate
Sheets("information").Updater.Delete
End Sub

however it does not seem to work? The purpose of the commandbutton is
to run a once off macro.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=555947

Reply With QuoteReply With Quote