+ Reply to Thread
Results 1 to 5 of 5

Activating hidden sheet using a drop down menu

  1. 11-08-2012, 04:49 PM #1
    mando415
    mando415 is offline
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Activating hidden sheet using a drop down menu

    I have a workbook that contains 7 different hidden worksheets (English, Spanish, French, etc.). i also have a drop down validation cell on an instructions worksheet with the above mentioned worksheet names.

    Will someone please guide me through the process of writing a vba script that will activate the hidden worksheet based on the criteria selected in the drop down???

    What i ideally would like is for a user to open this file, see a drop down with language options, selects preferred language, and that worksheet appears.

    Any help is greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 11-08-2012, 05:19 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Activating hidden sheet using a drop down menu

    mando415,

    Welcome to the forum!
    This code goes in the appropriate sheet's code module. So open the VBE (Visual Basic Editor) with Alt+F11 then double-click the sheet that contains the language selection drop-down. Paste this code in there, and adjust the Target.Address(0, 0) = "A1" .... to be the correct cell address of the language selection drop-down.
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 11-08-2012, 06:05 PM #3
    mando415
    mando415 is offline
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Activating hidden sheet using a drop down menu

    Disregard this. my mistake
    Last edited by mando415; 11-08-2012 at 06:38 PM. Reason: disregard
    Reply With QuoteRegister To Reply
  4. 11-08-2012, 06:33 PM #4
    mando415
    mando415 is offline
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Activating hidden sheet using a drop down menu

    tigeravatar,
    Thanks so much! So easy and simple... May i ask you one more related question. I created the below macro (controlled through form control in each worksheet) to unprotect the worksheet and send in email. How do I modify code to unprotect the selected sheet as they will now have different names? I am asuming it will be modifying this line - Sheets("RequestForm").Unprotect Password:="123"?

    The macro code is as follow...

    Thanks again!
    ------------------------
    Please Login or Register  to view this content.
    Last edited by mando415; 11-08-2012 at 06:55 PM.
    Reply With QuoteRegister To Reply
  5. 11-08-2012, 08:40 PM #5
    mando415
    mando415 is offline
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Wink Re: Activating hidden sheet using a drop down menu

    tigeravatar,
    I was able to figure out my second question. Again, thank you so much for your help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1