+ Reply to Thread
Results 1 to 4 of 4

Cannot find sheet referenced in a formula

  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Cannot find sheet referenced in a formula

    Hi,

    I have received a sheet for my works.

    It refers to one of the sheets on the formulas (SOR SHEET
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    ? But, I cannot find the sheet with name SOR Database even in the hidden sheets.

    How is this done (may be VBA) ?

    Is there any NON-VBA method to do hide sheets this way AND / OR to unhide the sheets ?
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,117

    Re: Cannot find sheet referenced in a formula

    Sheet12 is called SOR database...It's setting was "xlSheetVeryHidden"
    Attached Files Attached Files
    Last edited by sintek; 02-01-2021 at 06:23 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Re: Cannot find sheet referenced in a formula

    Thanks Sintek

    Is there a way to make "Veryhidden" using Excel user interface, without going to VBA

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,854

    Re: Cannot find sheet referenced in a formula

    You can do it in the VB Editor using the properties grid (without VBA), but there's nothing in the main Excel UI, no.
    Rory

+ 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. Row containing all the sheet/file names to be referenced by a formula
    By lacrimology in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2020, 12:56 PM
  2. Formula to find which tab is being referenced
    By mrsak87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2019, 03:47 PM
  3. [SOLVED] Changing Sheet Referenced by Formula Avoid #REF
    By SamFitz in forum Excel General
    Replies: 6
    Last Post: 09-06-2016, 09:28 AM
  4. Formula to find dates with a different format from the referenced cell
    By stpeter in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2013, 03:45 PM
  5. [SOLVED] Macro to Find & Replace existing formula with text in referenced cells
    By sonyap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 10:39 AM
  6. Replies: 1
    Last Post: 03-01-2011, 03:31 PM
  7. Replies: 2
    Last Post: 01-12-2006, 10:35 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