Web26 jul. 2024 · Within the code of Sheet 1 (Alt 11) I populate the following: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Application.ScreenUpdating = False Worksheets("Sheet 2").Visible = xlSheetVisible Sheets("Sheet 2").Visible = True Sheets("Sheet 2").Select Application.ScreenUpdating = True End Sub WebHere’s how: Under the “ Protected sheets and ranges ” box, select “Sheet.”. Choose the tab to protect from the drop-down. Click on “ Set permissions ”. Select “Restrict who can edit …
Hide or restrict access to individual worksheets
WebHere’s how: Under the “ Protected sheets and ranges ” box, select “Sheet.”. Choose the tab to protect from the drop-down. Click on “ Set permissions ”. Select “Restrict who can edit this range ” and choose “ Only you ” from the down arrow. Read more: How To Hide Tab From Certain Users in Google Sheets. Web1 jun. 2024 · It seems, you want to hide or restrict some tabs/sheet of workbook to some specific users. In Excel, you can protect/restrict some sheet in a workbook, but this is for … door spray paint
How to Password Protect / Lock an Excel Sheet for Viewing
Web12 jul. 2024 · View Sitemap; Search Search the Community. No results; Cancel. Sign in. ... Created on July 12, 2024. I am unable to hide sheets in one of my excel files I am unable to hide sheets in one of my excel files. just this one file that I know of. No problems with the many other files that I work with. This thread is locked. Web16 jul. 2024 · Hiding Excel Sheets from specific users. I have an excel file uploaded on OneDrive and have shared it with a team. It's a daily activity report so I want certain … Web17 mrt. 2024 · Open the workbook where you want to hide or unhide sheets. Press Alt + F11 to open the Visual Basic Editor. On the left pane, right-click ThisWorkbook and … city of menasha recycling schedule