Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Out
Hi,
I have a quite large sheet that has seven worksheets which tracks expenditure vs budget. Apart from the worksheet that the end user can see, all the other six sheets are password protected and the workbook is password protected. People authorised to update the source data have to enter a password via an InputBox using VBA that unprotects the various sheets and the workbook. On saving, the BeforeSave event reprotects the sheets and workbook. My question is, is there a way to reprotect or exit the file if no data is entered or the mouse is not moved for a given time to prevent anyone seeing the unprotected sheets if the authorised user walks away and leaves the normally hidden sheets visible? I know this will rely on Macros being enabled and all that entails but this is not an issue in this case. TIA, Regards, Alan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Out
A slightly different approach is to leave the sheets protected, with unlocked
"Input Cells" where the user enters data followed by clicking on a cmd button. If the user has entered a correct login password, the cmd button action will unprotect, transfer the data to your "data" sheets, then protect again. Another way is to use UserForms for inputting or editing data. Clicking an OK button will then do the same: check the password, unlock the data sheet, post the data and reprotect. "Alan" wrote: Hi, I have a quite large sheet that has seven worksheets which tracks expenditure vs budget. Apart from the worksheet that the end user can see, all the other six sheets are password protected and the workbook is password protected. People authorised to update the source data have to enter a password via an InputBox using VBA that unprotects the various sheets and the workbook. On saving, the BeforeSave event reprotects the sheets and workbook. My question is, is there a way to reprotect or exit the file if no data is entered or the mouse is not moved for a given time to prevent anyone seeing the unprotected sheets if the authorised user walks away and leaves the normally hidden sheets visible? I know this will rely on Macros being enabled and all that entails but this is not an issue in this case. TIA, Regards, Alan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |