Removing a password from a worksheet

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Removing a password from a worksheet

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-21-2013, 03:00 AM

funkyfido

Windows XP Removing a password from a worksheet

Office 2007

Novice

Join Date: Jun 2013

Posts: 24

Quote:

Originally Posted by BobBridges

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.

Tags

password, remove password

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 AM.