User has to click button to mark task as complete....

[jfarlow]

Hi

I have a spreadsheet that users update which I then want them to perform a number of checks on. At the bottom will be a button for them to click stating "Click here to confirm checks completed". When they click it I want it to put a flag somewhere that I can then use to prevent them from saving if they haven't clicked the button. I know how to do the saving but, but how do I get the button to put a flag somewhere?

Thanks

[Andy Pope]

Rather than a button use a checkbox. You can link the checkbox to a cell and that cell will be True or False.

If you want to stick with the button you will need code to store the information in a cell or named range.

[jfarlow]

perfect - thanks.

[jaypee207]

Hi,

My name is Jasper, I was wondering to make a macro button in which it will mark all cells with an "X" mark in column A if only column B, C cells contains data.

Thanks for your help,

Jasper

[arlu1201]

jaypee207,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.