+ Reply to Thread
Results 1 to 2 of 2

Command button to Hide a tab and unhide a tab with a password

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Command button to Hide a tab and unhide a tab with a password

    Hi, I'm a newbie here as far as posting, but I've gotten some great advice from other threads, but I can't find anything that will work for what I'm trying to do now.

    I have a spreadsheet with several tabs. I would like one tab (the Setup tab) to be hidden so that our customers do not have access to it. However I need to keep the tab on the spreadsheet as it feeds information into the other tabs, and our employees will need to have access to the tab frequently.
    I would like 1 command button that will hide tab when clicked.
    I would like another button to unhide the tab after requesting a password.
    Any help would be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: Command button to Hide a tab and unhide a tab with a password

    See royUks work here

    http://www.excelforum.com/excel-prog...-tabs-vba.html

+ 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