View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bri[_2_] Bri[_2_] is offline
external usenet poster
 
Posts: 2
Default Form and protect sheet

Hi - I have a worksheet and colleagues prefer to input data (including new
data) by using the 'Data - Form'. However, if I protect the sheet (Tools -
Protection - Protect Sheet), then the option to create a new record or
delete an old one is grayed out in the form. Is there a way round this? I am
using Excel 2003.

Any advice would be appreciated.
Brian.