Stop users deleting& inserting rows
Hi,
when you protect the sheet you can select from the list what the managers
can do in that way you don't need to provide them the password avoiding
people inserting or deleting rows
"Jock" wrote:
A workbook is read only unless a password is entered to allow read/write for
managers only.
Once unlocked, the managers can add/change details as necessary.
I want to stop them from deleting and inserting rows thus forcing them to
add new data to the bottom of the existing data rather than inserting a row
randomly elsewhere.
Thanks.
--
Traa Dy Liooar
Jock
|