Forum Discussion

StMarys71's avatar
StMarys71
Copper Contributor
Dec 16, 2022

Passwords

Please could somebody tell me how to create unique passwords for users on different sheets. I do not want users to be able to see any other sheet apart from their own, that they will have a password for. 

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    sharepoint can assign read or write rights to workbook file。
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    StMarys71 

    Based on your text, it is not clear whether you are working in a network, Sharepoint, OneDrive, etc.

    It is also not possible to see which Excel version you are working with.

    If I may recommend, more detailed information would help those users who want to help.

     

    Anyway, here's an old file that I got from the internet (unfortunately don't remember which site to send you the link from), used a few times...does your job.

    This file is in VBA, I don't know if this is possible for you.

     

    You can also try Share Workbook, here is a link with video instructions.

    Share your Excel workbook with others

     

    Hope to have helped anyway.

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Share

Resources