View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default disallowing insertion of rows

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.