View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Nasir.Munir@dal.ca is offline
external usenet poster
 
Posts: 37
Default disallowing insertion of rows

smiles :)
thank you, never thought of that, silly me
Nasir.


Kevin B wrote:
You can accomplish that with Protecting the worksheet. If you're using Excel
2003 you can cherry pick the options you want to allow your users to do.
--
Kevin Backmann


" wrote:

Is there a way of disallowing users to insert a row. I just dont want
anyone to insert any row, becuase my sheet is hyperlinked with other
sheets. Any insertion will ruin the hyperlink. Can anyone suggest
something?
Thanks,
Nasir.