Dear All
Here is very tough job
I got my solution from Excel forum for giving user wise access to work sheets
I need One Extra form after user validation
With That User can select which type of Worksheets he want to see. Following are 3 options.
1) Resort
2) Adventure
3) Both
In attached file there is user form named frmAccess
once user validate, after that new form should appear then
New form should display 3 Option Buttons for Above mentioned Three Options
If user will select first Option button (Resort) then
All worksheets which names are ending with word "RES" only will be visible
If user will select Second Option button (Adventure) then
All worksheets which names are ending with word "ADV" only will be visible
If user will select Third Option button (Both) then
All worksheets which names are ending with word "RES" or "ADV" all will be visible
I have attached file and username and password for that file is same "admin"
If you want to give these three option buttons in existing Form named "frmAccess" then also it is fine for me
But Please make sure that, after adding new option buttons, it should not affect on user level access program of that form.
Please provide solution in Excel 2010 Version
Please help me out from this issue which is worst and top most imp ever in my life
Thanks in Advance
Atul
Bookmarks