Forum Discussion

Elsita Garcia's avatar
Elsita Garcia
Copper Contributor
Jan 03, 2018

Password Protecting & Sharing Workbook

Hi,

 

I really need some help. We use a spreadsheet in work to record flexi. The key requirements we need to add are:

1) We are able to lock master cells so that the content, look and structure of the sheets cannot be changed;

2) We are able to track changes and ensure that these cannot be edited or removed (password protect this feature if possible with a master password); and

3) We are able to password protect the wokbooks (with unique passwordd for each user s that they can open and amend the non master cells and reord their times daily. but NOT remove track changes

 

Can someone please help me with advice as to how to set the above 3 functions up?

 

Many thanks in advance,

 

E

No RepliesBe the first to reply

Resources