Log In
Register
Home
July 6, 2021
Offline
Hello,
I really need help with some of the VBA coding that I am attempting. When I try to open my workbook and enter a User Name & Password, something is causing the error to display or hide certain sheets - at least that is what I gather from the description of the error. I have been researching on many online resources and I can't figure out how to fix this error - or really why it's occurring. The original workbook pages were not protected or hidden - so I am at a total loss as to how I can fix this. 
I will be forever grateful if someone can help me with a fix.
I have attached my report and the User Name and Password is:
User Name = James
Password = pw123
This is just something built for testing, so there is no confidential or real information here. Please feel free to update and make changes if needed to test it.
Thank you in advance for the help! 
Annalisa
Trusted Members
Moderators
November 1, 2018
Offline
The Activate code in the form protects the workbook. That means that you can't then change the visibility of any sheet unless you unprotect the workbook again first.
July 6, 2021
Offline
I removed the line in the Activate code in the form, but nothing happens. I don't get the error any longer, but no sheets appear. The Login screen shows and stays but nothing else is happening. Am I missing something else?
I have attached the updated file with the code line "ThisWorkbook.Protect 1234" removed
Please let me know.
Thanks!
Annalisa
Trusted Members
Moderators
November 1, 2018
Offline
They are visible, just not active - you still have the front sheet selected which is entirely grey. Also, the sheet tabs have been hidden so there is no obvious way for the user to navigate in this workbook.
1 Guest(s)
