Multifunction Button

[David_R]

Hi,

My Excel Spreadsheet has:

• a Shape which is intended to act as a button
• Column D is hidden
• Cell F5 is formatted as Time and is currently set to 00:05:00 (i.e. 5 minutes)
• Cell Range E12:E21 where the user is going to enter values (e.g. answers to questions)

I would like the user to be able to click on the button/shape, and this would:

• Unhide Column D
• Start a countdown to zero in Cell F5
• When the countdown reaches zero the Range E12:E21 are automatically protected/locked so the user can no longer update them (a pop-up message saying "Time's Up!" would be a nice to have, but not essential)

Is it possible to do all three of these things with the one button/shape using VBA and if so what would the code look like?

Thanks
David_R

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.