Command Button Changes Data Each Time It Is Pressed - Want it to workonce per worksheet.

Posted to microsoft.public.excel.programming

Ian[_4_]

external usenet poster

Posts: 85

Command Button Changes Data Each Time It Is Pressed - Want it to work once per worksheet.

Hadn't thought that far ahead, but glad it worked.

Ian

wrote in message
...
Thanks Ian,

I had to modify it a little as making A1="Done" means that it will
carry over when the sheet is copied. As I have a macro to copy the
sheet it will now delete the A1 cell on the new sheet.

Cheers

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Enter button jumps to next cell each time its pressed!!!!	evasmagacz	Excel Discussion (Misc queries)	3	June 17th 07 08:37 PM
Use A Command Button more than one time	Bull	Excel Programming	1	April 23rd 07 05:37 PM
Store data JUST entered in Activecell after clicking command button on worksheet	[email protected]	Excel Programming	1	August 23rd 06 04:20 AM
upload data from an excel worksheet to SQL W/ a command Button	cdneely	Excel Programming	0	November 15th 05 04:17 PM
Can't select macro button after other button is pressed	C. Campbell	Excel Programming	1	November 30th 04 07:46 PM

All times are GMT +1. The time now is 07:00 PM.

Menu

About Us