|
|
#2
02-25-2012, 10:45 PM
|
|||
|
|||
INsert this line at the begining of your code, to unprotect worksheet, a macro cannot make those changes on a protected sheet:
activesheet.Unprotect Password:="Secret" At the end of the code, you may want to protect it : Activesheet.Protect Password:="Secret" 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Insert/Paste Picture into Protected Worksheet
|
udea | Excel | 1 | 02-06-2012 07:43 PM |
|
"Auto-populating" data-worksheet to worksheet.
|
meggenm | Excel | 4 | 02-04-2012 02:04 AM |
|
Word mail merge from a protected Excel worksheet
|
Platform | Mail Merge | 10 | 09-28-2011 05:12 AM |
| Cell Comments in a Protected spreadsheet | dmgerber | Excel | 1 | 06-06-2010 05:10 AM |
| click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |
Windows Vista 
Office 2010 32bit
Threaded Mode