All, I am trying to deploy a timed excel case study for interviewing purposes but am having trouble thinking of a creative way to enforce time without just sending the worksheet when they need to start and asking them to send it back when they are done.
Is it possible to do the following?
1. Create a sheet in the workbook that says the tabs will be revealed upon enabling macros
2. When macros are enabled, a 60 minute timer begins
3. When 5 minutes are left, the workbook warns the user time is running out
4. When 60 minutes is reached, the file gets saved and closed
Any help would be greatly appreciated, I cannot seem to find a solution for this anywhere.
Is it possible to do the following?
1. Create a sheet in the workbook that says the tabs will be revealed upon enabling macros
2. When macros are enabled, a 60 minute timer begins
3. When 5 minutes are left, the workbook warns the user time is running out
4. When 60 minutes is reached, the file gets saved and closed
Any help would be greatly appreciated, I cannot seem to find a solution for this anywhere.