Disabling Control Button After It has been clicked once

CorpusSpongiosum · Mar 17th, 2002, 09:18 AM

I have aspreadsheet that contains a control button to enable the user to eamil the sheet by clicking on the button. How do I disable this after it has been pressed to prevent multiple copies being emailed by enthusiastic mouse clickers. Is it also possible to dim the control button or change it's colour once it has been clicked?

Thanks

Craig

Mudface · Mar 17th, 2002, 09:39 AM

In the click event sub of your command button, add the following at the end, this will also grey out the button: -

CommandButton1.Enabled = False

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 09:18 AM	#1
CorpusSpongiosum New Member Join Date: Mar 2002 Posts: 9	I have aspreadsheet that contains a control button to enable the user to eamil the sheet by clicking on the button. How do I disable this after it has been pressed to prevent multiple copies being emailed by enthusiastic mouse clickers. Is it also possible to dim the control button or change it's colour once it has been clicked? Thanks Craig

Mar 17th, 2002, 09:39 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	In the click event sub of your command button, add the following at the end, this will also grey out the button: - CommandButton1.Enabled = False