+ Reply to Thread
Results 1 to 6 of 6

How to setup a password for the excel?

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    How to setup a password for the excel?

    How to set up the password for lock the excel that someone can't change the items and information on that excel....

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to setup a password for the excel?

    .
    https://stackoverflow.com/questions/...book-using-vba

  3. #3
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: How to setup a password for the excel?

    Thank you your great help....
    I think it's useless.
    How can I lock the cell and row?
    And then, how can I lock or unseen the excel functions such as formula?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: How to setup a password for the excel?

    Maybe you can Google how to do this...

    https://www.ablebits.com/office-addi...k-cells-excel/
    HTH
    Regards, Jeff

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How to setup a password for the excel?

    .
    Your original question was :

    How to set up the password for lock the excel that someone can't change the items and information on that excel....
    Since you did not specifically name "cell and row", one would be led to believe "excel" meant the worksheet or perhaps the workbook itself.


    Your additional comment :

    Thank you your great help....
    I think it's useless.
    Is taken as a sarcastic retort to my genuine attempt to assist you.



    At this point, with the exception of Jeffrey Brown, I would be confused if anyone else offered to assist you now or in the future.


    Have a wonderful day sir ...
    Last edited by Logit; 10-08-2018 at 11:02 PM.

  6. #6
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: How to setup a password for the excel?

    Quote Originally Posted by Logit View Post
    .
    Your original question was :



    Since you did not specifically name "cell and row", one would be led to believe "excel" meant the worksheet or perhaps the workbook itself.


    Your additional comment :



    Is taken as a sarcastic retort to my genuine attempt to assist you.



    At this point, with the exception of Jeffrey Brown, I would be confused if anyone else offered to assist you now or in the future.


    Have a wonderful day sir ...
    Sir, I'm very sorry about that.
    Thank you your great help...
    I appreciated your answer. Why am I saying like that? Because I misunderstand you and your answer.
    Your helpful for everyone here is appreciated and very sorry about my comment again.

+ 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. Replies: 0
    Last Post: 03-28-2018, 02:49 AM
  2. [SOLVED] Activate "sorting" feature when worksheets are setup to "password protect" itself
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 09:04 PM
  3. Replies: 1
    Last Post: 04-29-2006, 12:50 PM
  4. Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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