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

HTH
--
AP

"funkymonkUK" a
écrit dans le message de news:
...

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