+ Reply to Thread
Results 1 to 4 of 4

protect a sheet?

  1. #1
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    protect a sheet?

    is there somehow to protect 1 sheet in aworkbook than the other sheets , so if anyone try to open it , it ask for a password ???
    and to hide the moudles code or also protect it with a password ??

    is that possible ??

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Tools Protection Protect Sheet
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon nasser

    I have a template available that is designed for multiple users. You as administrator assign each user a username and password and determine each users access rights (ie which sheets they can see). When a user opens the sheet they must enter their username and password and will only be able to work on the sheets that you have allowed them. You as administrator will be able to see all sheets.

    If this sounds like something you could use then PM me your e-mail address.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216
    Quote Originally Posted by dominicb
    Good afternoon nasser

    I have a template available that is designed for multiple users. You as administrator assign each user a username and password and determine each users access rights (ie which sheets they can see). When a user opens the sheet they must enter their username and password and will only be able to work on the sheets that you have allowed them. You as administrator will be able to see all sheets.

    If this sounds like something you could use then PM me your e-mail address.

    HTH

    DominicB
    I think it will be what i want
    to be more clear ... i have a workbook and i want to protect 1 sheet in it from even viewing , if any clicked on it to open , it ask for a password , and then i want to protect this code also from the user if they accessed this sheet

+ 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