Thread: Unprotect Cells
View Single Post
 
Old 01-05-2015, 08:56 AM
Cardinal2 Cardinal2 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2013
Posts: 10
Cardinal2 is on a distinguished road
Lightbulb Unprotect Cells

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
Reply With Quote