Hi,
I have this code below that is designed for 5 Users:
The first User - once the user has successfully entered the correct Username and Password - they get access to sheet1
I am having difficulty assigning sheet2 for the 2nd User and so on... Can anyone shed some light on this?
This code is what is in the "ThisWorkBook"
Please Login or Register to view this content.
Please Login or Register to view this content.
Best Regards,
John
Please Login or Register to view this content.Please Login or Register to view this content.
Ben Van Johnson
Capture4.JPGCapture3.JPG
Above ARE ERRORS...
Any ThoughtsPlease Login or Register to view this content.
Last edited by JJFletcher; 11-08-2014 at 01:12 AM. Reason: Corrected Uploads
I have gone back to the previous code above - it was not causing errors... I would like to ask if anyone can assist in navigation for the remaining four (4) users in the code - the first person Alberta is going to the sheet 1 - how does the code get changed so user tow (2) has a different sheet and so on for the next users etc...
Best Regards,
John
Good Morning - Thought I would wake up and get a fresh set of eyes on this issue before giving up - I have gone back to the first code above - it was not causing errors... I would like to ask if anyone can assist in navigation aspect of the code for the remaining four (4) users in the code - the first person Alberta is going to the sheet1 - how does the code get changed so users two through five get directed to a different sheet etc...
Best Regards,
John
Winon - I see you are here - Any Ideas - you have helped before - not understanding how to add more then one user to this code! Works great for the first User and sheet
John
Hello JJFletcher,
Could you please attach a sample workbook, as I would hate to create one, different to your set-up.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Thank you.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon,
Please find attached a sample for your review...
I am torn with this code because it provides - or is supposed to provide a multiuser point of access - I only wish this code would be more easy to understand - I am trying to use this type of access for multiple users because this sheet will be duplicated 5 times for 5 different Admin staff members. Each sheet will have a specific name for that staff member etc...
Possible a splash screen type entry so that basic users have only read only access and interact with this screen and Admin staff have access to specific sheets - pre determined in the code... etc...
Here is the sample for your review!
HR Dashboard Master V3.1.xlsm
John
Hi JJFletcher,
What version Of Excel are you using?
With my Excel 2007, I get some Errors trying to open your Workbook.
When I side-step that, VBA does not play along and cries about some missing DLL, or it will say Method or Data Member not Found.
Excel 2013
Thank you.
Please leave it with me for a while-maybe a day or what, so that I can see how to work with it in Excel 2007.
I notice that you do have an "Add Data" button, which demands a Password in any case. The Inputbox for this control is not a good idea, and security could be compromised, if someone else happens to see the Text entered.
Would you mind me changing that?
I do not mind the modification - yet this access must be restricted to authorized users only
John
Winon,
Can't that simply be masked ie: ***** with the current code?
Thanks all for assisting - but I have solved this issue - Thanks a lot all!
John
Last edited by JJFletcher; 11-09-2014 at 10:46 AM. Reason: spelling
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks