|
|
#3
11-20-2013, 10:21 AM
|
||||
|
||||
If ActiveSheet.Unprotect earns a subscript error, then I wonder whether there's no ActiveSheet just at the moment. Sounds silly, but after all that's what a subscript error should mean in that context. What happens if you try pointing to the sheet using the sheet name instead of ActiveSheet, say 'MyWorkbook.Sheets("MyWorksheet").Unprotect'?
|
| Tags |
| password, remove password |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Password protected file no longer offers password dialog on Open | htaylor | Word | 0 | 10-15-2013 12:35 PM |
 How to summarise different worksheet to a summary worksheet
|
samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
|
Outlook requests password afeter changing windows password
|
pask | Outlook | 5 | 03-16-2012 08:43 AM |
|
Removing password protection
|
HantsDave | Word VBA | 9 | 03-08-2012 11:57 AM |
|
Trouble Removing Password
|
cure4glass | Word | 1 | 02-17-2012 07:19 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode