Hi,
My Excel Spreadsheet has:
I would like the user to be able to click on the button/shape, and this would:
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
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