+ Reply to Thread
Results 1 to 2 of 2

Sheet opens when data keyed in on specific cell

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    Quezon City, Philippines
    MS-Off Ver
    2010
    Posts
    7

    Sheet opens when data keyed in on specific cell

    Hello Everyone,

    Can someone help me with a vba where a very hidden sheet(Sheet 2)becomes visible when a username is entered on cell B3 (Sheet 1) and for sheet to become very hidden again after they export the data to pdf. I just pictured this in my head and not really sure how to do it and if it's possible. Appreciate all the help I can get.

    Leng

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Sheet opens when data keyed in on specific cell

    -You have this thread in the "Access" forum.
    - you have started several threads that have answers, you need to acknowledge the answers and mark the threads as "Solved" if they are solved.

    Read the Yellow banner at the top of this web page to see how to attach a sample workbook.

+ 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. Code to Auto-Open New Window that Opens Specific Sheet w/ Windows Arranged Vertically SbS
    By chparkervatech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2021, 03:39 PM
  2. Ensure that workbook opens with a specific sheet visible
    By andypnz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2020, 12:39 AM
  3. [SOLVED] Scrambled Manually Keyed Data in Data Connection Table
    By morerockin in forum Excel General
    Replies: 2
    Last Post: 03-18-2020, 07:44 AM
  4. [SOLVED] when excel workbook is opened it always opens specific sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 07:15 AM
  5. Replies: 1
    Last Post: 04-19-2013, 03:42 AM
  6. [SOLVED] Specific cell selected when sheet opens...how???
    By Ron M. in forum Excel General
    Replies: 3
    Last Post: 02-16-2006, 10:40 PM
  7. how can i test whether cell contains keyed constant or a formulae
    By Ruthki in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 09-06-2005, 12:05 PM

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