I have a spreadsheet that I unprotect, copy date into and
then protect again.
I use the commands "Sheets("MainDataEntryForm").Unprotect Password:=""

Sheets("MainDataEntryForm").protect Password:=""

but I would after protect the main data form, I would add a command to unprotect cells , B2, B7, b10 so that users can enter data into those specific cells only but no other cells.
any help would be appreciated.
thanks
Cardinal2