Results 1 to 7 of 7

Need VBA Code to Open Hidden sheet when click corresponded value in Cmbox1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Need VBA Code to Open Hidden sheet when click corresponded value in Cmbox1

    Hi experts

    i have create list box validation team wise, i want vba command to go to particular sheet for selection of sheet name

    if i click IT in comboBox1 and click command , combo sheet should open, then when i back to sheet the opening sheet should hide back.

    There is 2 sheet have abbreviation as sheet name becoz some team is look long,even team member not understand short abbreviations so i keep long string like Business Order Management in bombobox, but in sheet tab BOM

    2.Vendor Logistic Team have abbreviation as VLT in sheet tab.


    Help on this

    Regards
    JohnMN
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. click the hyper link open hidden sheet with asked password
    By sudbhavani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2020, 01:59 AM
  2. [SOLVED] VB Code to open hidden sheet workbook by Bypassing password
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2018, 10:45 AM
  3. [SOLVED] Macro to Double Click 2 cells to create a copy of a Hidden Sheet.
    By harryco79 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-29-2015, 12:12 PM
  4. VBA to open a hidden sheet
    By ScottBeatty in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2013, 11:53 AM
  5. [SOLVED] Go to a specific sheet if the sheet to open in the macro is hidden?
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2013, 03:45 PM
  6. [SOLVED] VBA code to 'click' Open in the Open or Save dialogue box on a webpage?
    By bensox in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-31-2012, 05:40 AM
  7. [SOLVED] 2 windows open when i click F1 in VB code
    By tamila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2006, 10:25 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1