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.