Hi all - i built a simple wb that is a survey... 1 question, yes or no buttons.
the button that is pressed adds one to another sheet (tally of answers) then saves the workboook.
when the option is selected a shape appears over the yes/no buttons saying thanks for your response and then goes away after a minute.
here is my problem and question.:
problem: people being people keep being a**holes and modifying the buttons, layout etc such as flipping buttons around, deleting texts.
question: is there a way to stop this? can i protect all of the contents from being modified but somehow still run the macro? i have seen where a code can call to unlock with password, then run macro, then relock with password via VBA....
thanks for your help and hope that made sense. cheers legends.
the button that is pressed adds one to another sheet (tally of answers) then saves the workboook.
when the option is selected a shape appears over the yes/no buttons saying thanks for your response and then goes away after a minute.
here is my problem and question.:
problem: people being people keep being a**holes and modifying the buttons, layout etc such as flipping buttons around, deleting texts.
question: is there a way to stop this? can i protect all of the contents from being modified but somehow still run the macro? i have seen where a code can call to unlock with password, then run macro, then relock with password via VBA....
thanks for your help and hope that made sense. cheers legends.