Re: In Excel protect or unprotect multiple tabs with one password at .

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 09/16/04


Date: Thu, 16 Sep 2004 09:12:50 -0600

here's a solution from the archives:

http://google.com/groups?threadm=jemcgimpsey-DF70AB.10440023042004%40msne
ws.microsoft.com

You can search for other solutions in the archives at:

    http://groups.google.com/advanced_group_search?q=group:*excel*

In article <17C818A6-A73E-45C0-9767-17F4C1BC1F05@microsoft.com>,
 Tony-EPIC <Tony-EPIC@discussions.microsoft.com> wrote:

> I create budget templates with multiple tabs. They include complex formulas
> that move information from one tab to another and from one file to another.
> I unprotect areas where managers can enter their budget numbers and protect
> all my formulas. For easy of remembering, I use the same password on
> multiple tabs in each file. Currently I have to click on each tab and
> protect or unprotect the dtab to make changes int he protected areas. It
> would speed up the process if I could select multiple tabs and protect or
> unprotect all the selected tabs with the same time with the same password all
> at one time.



Relevant Pages

  • Windows XP Tour Protection
    ... on one of the tabs there's a possibility to ... check which key-combinations to allow windows to "see" ... >How can I protect a program where it can be used, ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Importing music
    ... While you are in one of those tabs... ... make sure it isn't set to "protect" ... > Open Windows Media Player, from the Toolbar select Tools, Options... ... >> The Movie Maker will not import music from my Microsoft ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: No desktop tab in display properties
    ... Restore desktop and screensaver tabs ... Folder customizations ... Protect your PC! ... Am I stuck with the XP wallpaper forever? ...
    (microsoft.public.windowsxp.customize)
  • Re: prevent change sheet name
    ... Another ways is to protect the tabs via Workbook protection (Tools / ... Protection / Protect WorkBook) manually. ... Jose Luis ...
    (microsoft.public.excel.programming)
  • Re: Tabs, Portal and Mail
    ... > it opens every link from Usenet in a new tab. ... I kept 'losing' tabs if links were opened in the tab currently ... >> Firefox requires 2 persistent keystrokes. ... My obsession with archives sometimes scares me. ...
    (alt.html)