View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default errrors while trying to delete a commandbutton

You code works for me in Excel 2003. Ensure that the sheet is not
protected.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"funkymonkUK"
wrote
in message
...

sorry i am having troubles with the code.

I have the following

Private Sub updater_Click()
Range("a1").Activate
Sheets("Information").OLEObjects("updater").Delete
End Sub

and am getting a Runtime 1004 : Application-Defined or
object-defined
error.

i have no idea why this could be happening.


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