Thread: Removing a password from a worksheet
View Single Post
 
Old 11-21-2013, 03:00 AM
funkyfido funkyfido is offline Windows XP Office 2007
Novice
  
Join Date: Jun 2013
Posts: 24
funkyfido is on a distinguished road
Default
Quote:
Originally Posted by BobBridges View Post
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'?

Tried this but no joy either.
Reply With Quote