errrors while trying to delete a commandbutton

[funkymonkUK]

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.

 

[Ardus Petus]

Sheets'"information").oleobjects("updater").delete

HTH

 

[funkymonkUK]

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-define
error.

i have no idea why this could be happening

 

[funkymonkUK]

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-define
error.

i have no idea why this could be happening

 

[funkymonkUK]

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-define
error.

i have no idea why this could be happening

 

[funkymonkUK]

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-define
error.

i have no idea why this could be happening

 

[Mark Driscol]

Your code worked for me in Excel 2002.

Mark

 

[funkymonkUK]

i have excel 2000 if that helps

 

[funkymonkUK]

i have excel 2000 if that helps

 

[Chip Pearson]

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"
in message
news:[email protected]...

 

[Ardus Petus]

Please send your faulty workbook as attachment to (e-mail address removed)

HTH

 

[funkymonkUK]

yeah sorry it was password Protected works like a treat