View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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