Thread: Command Button Changes Data Each Time It Is Pressed - Want it to workonce per worksheet.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ian[_4_] Ian[_4_] is offline
external usenet poster
  
Posts: 85
Default 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 QuoteReply With Quote