+ Reply to Thread
Results 1 to 11 of 11

Remove sheet tab

Hybrid View

  1. #1
    Registered User
    Join Date
    04-02-2010
    Location
    Gwynedd, Wales
    MS-Off Ver
    Office 97
    Posts
    4

    Re: Remove sheet tab

    In my ancient Excel 97, assuming you don't want to work on the sheet too often, I would rename the sheet in question "use the hyperlinks", then I would open it and select White as the font colour for all cells (they won't be able to read anything with values the same colour as the fill) except one saying Please Use the hyperlinks as requested you **** then protect the sheet with a password. As far as I can tell, formulas linked to other sheets will still work. Without the password they won't be able to change the font colour even if they notice that the icon shows white.

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Remove sheet tab

    Attached a version working with hyperlinks
    Attached Files Attached Files


    click on the * Add Reputation if this was useful or entertaining.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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