+ Reply to Thread
Results 1 to 1 of 1

Create User Form to Display Specific Worksheets Using VBA Code

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    66

    Create User Form to Display Specific Worksheets Using VBA Code

    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
    Attached Files Attached Files
    Last edited by atulexel79; 06-14-2015 at 05:10 PM. Reason: Test Was Missing

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-27-2015, 01:31 PM
  2. Replies: 4
    Last Post: 11-05-2014, 09:38 AM
  3. code won't display a selected image from a file picker, in a user form Any ideas?
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2014, 02:47 PM
  4. Display selected value from the user form in a specific cell
    By vignesh805 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 07:32 AM
  5. [SOLVED] Load a user form and display it at a specific screen location
    By PeterEd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2012, 02:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1