Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VeryHidden Sheet References (03)

    I am looking for a recommendation of how not to display the text or formula referencing a VeryHidden sheet. As an example Sheet2 is hidden using VeryHidden code. Sheet1 has a cell formula referencing a cell in the hidden sheet. Is it possible not to view the formula in Sheet1 referencing Sheet2.

    In theory someone could take a blank worksheet copy the formula to the blank worksheet and recreate the contents of the VeryHidden sheet. Why hide it if someone can reconstruct it in a few simple steps.

    Thanks,
    John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VeryHidden Sheet References (03)

    If you hide the fomula in format cells and protect the sheet the formula will not be displayed

    Steve

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VeryHidden Sheet References (03)

    Steve,

    Thank you. I can't tell you how many times I have seen that option but never really read what it does. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    John

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VeryHidden Sheet References (03)

    Is that a new option in XL2003 (I don't see that option on XL2K). If so, what happens if you open a workbook using it in XL2K?
    Legare Coleman

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VeryHidden Sheet References (03)

    If you select Format | Cells... and activate the Protection tab, there should be two check boxes: Locked and Hidden. Ticking the "Hidden" check box will hide the value/formula from the formula bar when the worksheet is protected.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: VeryHidden Sheet References (03)

    No it has been as far back as XL97. Perhaps my shorthand was not detailed enough. It is in the same location as the option to "Locked" or "Unlock" cells.:

    Format - cells
    Protection(tab)
    Check "Hidden"
    <ok>

    Steve

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VeryHidden Sheet References (03)

    OK, I found it. I wasn't expecting it to be on that tab.
    Legare Coleman

Posting Permissions

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