A main worksheet that is displayed immediately after opening a workbook. So please bear in mind when considering implementing this into your project that this is easily breakable if there is any malicious intent to gain unauthorized access.įirst, I would recommend a common landing zone. It sounds like according to the comments that this isn't as much as a security issue as it is a convenience issue. Response = InputBox("Enter password to view sheet") I have tried the following but it doesnt prompt a password to access the sheet Private Sub Workbook_SheetActivate(ByVal Sh As Object)ĭim MySheets As String, Response As String Rather than create multiple versions of the same workbook based on different users. Surely there's a password protect function that requires the user to enter a password to view a sheet. But I want to keep the workbook identical for all users but restrict access to certain sheets. There's a few methods that prompt an initial password to open various versions of the same workbook. I thought this would be a readily used function in Excel but it's surprisingly difficult to implement a simple process of restricting access to specific worksheets within a larger workbook.
0 kommentar(er)
