Multifunction Button

D

David_R

New Member
Joined
Feb 21, 2019
Messages
5
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
 
Sort by date Sort by votes
I'm glad to help you. I appreciate your kind comments.
 
Upvote 0

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

C
  • Question Question
VBA button click from within a macro
Replies
2
Views
885
Chris_yorks
C
B
  • Solved
Event code to give message box and change color of auto-shape
Replies
4
Views
729
bh24524
B
M
  • Question Question
I need help with VBA/macro script to collect user input and fill cells
Replies
4
Views
502
mumps
mumps
D
  • Question Question
Prompt To Allow User To Edit VBA
Replies
4
Views
359
Joe4
Joe4
M
  • Question Question
VBA - Find first empty cell in a row
Replies
2
Views
507
Mplz
M

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top