Password Protect Excel Worksheet From Viewing
In the protect structure and windows dialog box, enter a password into the password textbox, keep the structure box selected and then click the ok button. Clicking on the file tab on the excel ribbon and selecting save as from the list on the left hand side. Share documents with I concur with mathieu guindon that any vba attempt to restrict viewing access to an excel worksheet will be flimsy as explained by mathieu guindon. Password protect excel worksheet from viewing . Is there a way to hide a worksheet within a workbook and then protect it in such a way that any use can't see the worksheet. Unfortunately i don't believe you can password protect that worksheet however you may be able to achieve what you needing by using the protect workbook option. The first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. In the password to unprotect sheet box, type a password for the sheet, click ok, and then rety...