View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default How to avoid deleting of rows


"2foot" wrote in message
oups.com...
Hi,
I have a problem where I would like some help on.

I would like that the users can't delete or insert rows.
They should however still be able to Hide or Unhide rows.
They should also still be able to change the data in the cells of the
rows.

Is there anybody with a good solution?

Thank you

Wim


Depends on your Excel version. When you protect a sheet in Excel2003, you
can specify, that deleting and inserting of rows are forbidden, but that
other changes are allowed.
Joerg