|
|
#1
01-05-2015, 08:56 AM
|
|||
|
|||
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 
|
| Tags |
| unprotect cells |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to unprotect and search a Word2007 doc? | pstein | Word | 1 | 05-31-2013 02:50 AM |
| protect and unprotect in shared excel | mark-gabb | Excel | 0 | 01-09-2012 07:30 PM |
| ADD in That can unprotect the documents. | aligahk06 | Word | 0 | 07-12-2010 04:55 AM |
| Unprotect header in Word | Fran | Word | 0 | 12-23-2008 03:42 AM |
Windows 7 64bit 
Office 2007
Threaded Mode