If it is a button then just toggle the enabled property of the button...
Assuming the Button came from the Controls Toolbox and not the forms Toolbar.
The code for the Control toolbox will sit in the sheet. The forms toolbar
code will be in a module that you will have linked the button too.

sub CommandButton1_Click()
'Delete the lines
Sheets.CommandButton1.enabled = false 'Gray out the button
end Sub
--
HTH...

Jim Thomlinson


"gtton" wrote:


Hi Dominic, my macro deletes 4-5 cell rows when you hit a button. I
prefer if the user does not hit the button more than once because they
may delete important information further down the spreadsheet.


--
gtton
------------------------------------------------------------------------
gtton's Profile: http://www.excelforum.com/member.php...o&userid=24721
View this thread: http://www.excelforum.com/showthread...hreadid=383303