I am in the final stage of completing a file project but I am receiving the following error:
Runtime error 1004: Method 'Visible' of Object '_Worksheet' failed.
The last two tasks are 1) to prevent hidden sheet and column access and 2) currently closing the file from the "X" or File > Exit as both create the error message. If this can be solved it can be fine to close from the X or File > Exit as i will then add File Saving methods.
I understand the visiblity status of the worksheet is causing the error but how to correct or capture the error without leaving the workbook and/or worksheets unprotected and vulnerable to editing.
I have included a cut-down generic version of the worksheet.
The premise is staff update the fields in yellow and at the begining of each week the individual worksheets are reset i.e. the values of the Updated column become "No".
There is a Main Menu tab with Service buttons which change from red to green when all client details have been updated for the week in question.
There is an Admin tab currently used to store the "Reset Worksheet" button method but this tab can be removed if there is a more elegant solution.
If the solution I seek is not possible, what is a more logical way of preventing tampering within parts of the workbook.