View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pmms pmms is offline
external usenet poster
 
Posts: 8
Default when you protect a sheet, you can't enter using a form

I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess
with.....and then I protected the sheet. I wanted the user to enter data
using a simple form (from the Data menu)......but it's not letting me. Is
there a way around this? Or do I have to use the "vba form" stuff which I'm
not having a lot of luck with?

Thanks, in advance, for any helpful suggestions!
Paula