I would like to create a sheet using Format as Table feature which will include formulas. It works as long as the workbook is not shared and protected. But I need to protect the sheet with track changes on, is there a way to do this? Also, the cells below will be blank at first but as the file is saved for a new employee the admin would enter data in these cell. Can these cells be locked after the data has been entered?
C2:E2 (merged), will enter name
I2, will enter employee ID
L2, will add date of hire
N2, will add employee badge #
B4, will add a date
Any help will be much appreciated
Bookmarks