Forum Discussion
Creating a login process within a workbook
I’ve created a workbook where I want users to login on sheet 1 to be granted access to sheet 2 and if validated taken to a particular cell on Sheet 2. On sheet 1 I have a cell for ‘User Name’ and a ...
Before writing code, do a web search for something like "unprotect excel worksheet with password". You'll see how easy it is to bypass security. And worse, with that design you are planning to store - in plain text - the passwords of other users, so an intelligent user can not only break your security, they can also learn the passwords of other users and login as them.
Excel is not the right tool in which to write security code.
Hi Snowman,
Thanks for your response.
User access is just to a worksheet for authorized users to plan their weekly workload. Other sheets in the workbook are hidden and locked that contain data tables and formulas that populate cells on the planning sheet. So I’m just trying to allow a user specific access to a portion of the workbook.Per your suggestion I did do a search and watched a quick vid. So yes, super easy to unprotect a sheet or a workbook with a bit of effort that has protection enabled thru Excels security functions. Security on this is not critical, just to put up a soft roadblock.
