You could use the "very hidden" and you could encrypt the passwords and much much more, but in the end it is still in excel and therefore inherently NOT particularly secure. But don't worry, the bugs are included at no extra charge.ĪGAIN, Excel is NOT secure and therefore I made no attempt to make this particularly secure. I really didn't intend to spend this much time on creating this for you/others but I did and it is well past my bedtime so I haven't tested everything, fixed everything, nor added all the features that would be nice.
If the macro sees "R" or "RW" it makes the page visible and if it sees "RW" it also unlocks the page. After opening with the Admin account (Lotus 123) you can look at the "Main" tab to see how to add users, passwords and "R" or "RW" permissions for each page. i also have the PW for the VBA set to 123 and the master sheet/workbook PW set to 123 (that is a constant in the VBA on the frmPassword form code). The admin is Lotus with PW of 123 (thought that was funny). On open, all sheets except "Home" are hidden. In the attached is the VBA code to basically do what you want. I spent some time this evening initially 'scrubbing' my training matrix / report and then decided to just scrap it and write a very simple PW sheet control. I attached an example, sort of a rough draft, to As noted by previous commenters, Excel security is NOT secure! But I have done something similar to what you want for an internal document for training reports so employees can easily see their own reports but if they see others it isn't a big deal either. If the data is sensitive and you cannot risk users intentionally getting to other worksheets, then you'll have to find another way as Excel's internal "security" is not secure if people make any effort to break it. And, you would have to protect the VBA project so they can't easily get your passwords (but, this is also easy to break if one googles it). You would also need to run the protectsheet routine before saving and the unprotect routine after saving.Īlso, you would need to be sure to use the worksheet code names, which are viewable in the VBA project viewer or it is in the (Name) field when you click on the properties button in the developer tab, so that users can't circumvent your macro by changing the worksheet tab name. You should be able to get the user id using the environ function.Īnd, you would need to set up an event handler in the ThisWorkbook VBA module of your workbook to protect all sheets when opened, then get the user id and unprotect their sheet(s). But, if you still wanted to do it, then you would need to use VBA. Even someone with little skill can google the instructions to break it.
0 kommentar(er)
