Forum Discussion
excel sheet protect using password ?
I want to collect the responses online from multiple people in the excel file, but I want to protect individual excel sheet with a password, is it possible? I want to have responses in excel sheets/...
Thank you Hopkins,
Yes, I know about forms but there was some conditional formatting in the excel- using different color codes. That is the reason I wanted to use excel.
Ah, OK then Prakash Nimbalkar.
Unfortunately there is currently no way to do this in Excel Online.
With Excel desktop you can write VBA to protect and hide sheets based on passwords but
a) Only 1 user can enter data at a time
b) as Stefan Holmes mentions it's nearly impossible to make worksheets 100% secure
Sending out independent templates and then using Power Query to consolidate them is my current process.