+ Reply to Thread
Results 1 to 3 of 3

Different Password to Save (For Each Worksheets)

Hybrid View

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Saudi
    MS-Off Ver
    2010
    Posts
    5

    Different Password to Save (For Each Worksheets)

    Hi!

    I just want to ask if it is possible to have different passwords to save in each worksheets. For example, in Sheet1, the password to save is ABCD, while in Sheet2, the password to save is BCDE. Can you please help.

    Thank you!

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Different Password to Save (For Each Worksheets)

    Not sure this is possible with the sheets being in the same workbook. When a save is done, it is saved as the entire workbook, not by the sheet, so anytime you do a save, it will save all the sheets as well.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Different Password to Save (For Each Worksheets)

    Your question is confusing. You talk about saving (a workbook) and password protecting worksheets.

    Please clarify.

    You can of course password protect each worksheet with a different password.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Save as zip with a password
    By Ang12345 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-06-2021, 02:19 AM
  2. How to Save As a password-to-open workbook without a password?
    By ncalkins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2012, 07:02 PM
  3. password to save
    By The_Cat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2010, 08:18 AM
  4. [SOLVED] Can't Save Password in MS Query
    By Damon in forum Excel General
    Replies: 0
    Last Post: 08-01-2005, 06:05 AM
  5. Password on Save As
    By Ashman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2005, 01:05 PM

Tags for this Thread

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