You can only unhide through VBE, by changing xlSheetVeryHidden to xlSheetVisible Visible status xlVeryHidden means that you cannot unhide the worksheet in normal worksheet View (as if it doesn’t exist)
![excel vba on page activate sort excel vba on page activate sort](https://i.stack.imgur.com/BWZfr.jpg)
![excel vba on page activate sort excel vba on page activate sort](http://lh6.ggpht.com/_ywO7MX0I9V8/TJeFIgjUthI/AAAAAAAAALA/g9boOu3WjP0/w1200-h630-p-k-no-nu/image_thumb[13].png)
While password Hideall does the opposite.ĭummy = MsgBox("Incorrect Password", vbExclamation) When password is Showall, all worksheets become visible. Different password will open a different worksheet. This Macro prompts a user input box that asks user to enter a password. Press ALT+F11 and create a Macro as below. In that page, add a button, which can be either a Shape or an ActiveX Button, the purpose of it is to trigger a Macro. Step 1 – Create a menu pageĬreate a worksheet named “menu” that serves as a menu page. Therefore I was thinking about protecting each worksheet with different password so that I can distribute the workbook out in one email, instead of creating several workbooks and distribute several emails. For each worksheet, I want to send to different party, but I can’t send the whole workbook to everyone because they contain confidential data. Recently, I created a workbook with several worksheets inside. Protect worksheet (cells) with password.Hide the worksheet and add a password to unhide the worksheet.
![excel vba on page activate sort excel vba on page activate sort](https://www.teachexcel.com/images/uploads/e08707f611f6c2f720a51f2b6f2f8af8.jpg)
Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Users are asked to open the Excel file with password. There are several kinds of protection in Excel. Protect VBA code with password Different kinds of workbook protection
EXCEL VBA ON PAGE ACTIVATE SORT HOW TO
This Excel VBA tutorial explains how to hide worksheet with password (xlVeryHidden).Įxcel VBA protect worksheet with passwordĮxcel VBA Add password to Excel workbook in folder