Question about protecting worksheet.

[Austinhclark]

I built a worksheet for my job on my own time to make my job easier. It took ssveral hours to learn the code and much help from this forum to build. here is my question...

Our computers are shared. so my co workers have access to the same iles as me. as i buil this on my own time to make my job easier i would like to prevent my coworkers from using it. i knowthis sounds selfish but i was told by my boss that i could not devdlop the workbook on company time because it was foolish.

with that being said can someone explain to me how exactly protecting a workbook works? I would like for the file to be password protected and that only someone with the password can update the cells.

Thanks in advance

austin

[Palmetto]

Suggest you have a read here: Password protect worksheet or workbook elements

In Excel 2010, to set a password to open the workbook:

On the File Tab, click on Permissions button and choose Encrypt with Password. Anyone opening the file will have to enter the password to view the file.
WARNING: if you lose or forget the password you are OUT OF LUCK on opening the file (w/o aid of 3rd party cracking utilities).