WebApr 16, 2015 · I'm coding a macro where in the main menu there's a button to access the "Admin" worksheet where one can make important changes. I want only certain users to access this Admin worksheet, and I wonder if there's a way to password-protect viewing a worksheet, not just modifying it. WebOct 28, 2010 · Here is what you do in Excel 2007: In your sheet of interest, go to Home ribbon -> Format -> Hide & Unhide -> Hide Sheet and hide your sheet. Go to Review ribbon -> Protect Workbook, make sure Structure is selected, and enter your password of choice. Once this is done, the sheet is hidden and cannot be unhidden without the password.
How to protect worksheet from viewing in Excel? - ExtendOffice
WebAug 8, 2024 · Open your Excel document and switch to the password-protected sheet. You can do it by clicking on the file icon, it will open a list of options, select the info tab … WebCannot open one IRM protected project in Secure View - Office. As we mentioned above, it is possible into frank password protected Excel file. Plus this post bequeath tell thou how to open a password protected Excel file the or without knowing the password and make your spreadsheet workable once again. Into addition to all these solutions, this ... tab 8 test
Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel
WebMar 24, 2004 · The title is "Password Protect Tabs", which is do-able, among other ways, by protecting the workbook for structure, so the tabs cannot be renamed, deleted, or moved. If it's protecting the contents of worksheets that the OP meant by the subject line, then that's another issue. I was assuming that what he said was what he meant. WebOpen the file. Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select the Restrict permission to this workbook check box, and then select More Options. Under Additional permissions for users, select the This workbook expires on check box, and ... WebMar 15, 2024 · When all done, save & close workbook then re-open. You should see new tab “User List”. In Row 2: Col A your network UserName. Column B TRUE for admin user. In Row 1 Column 3 onward: All other worksheet names should be listed. All you need do is Add all the network user names in Column A as required. brazilian ip