Removing a password from a worksheet

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

FAQ

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 excelledsoftware

Interesting. The ActiveSheet.Unprotect Password:"Test"

works just fine for me. There are 2 things you can try. First ensure that "Test" is indeed suppose to be capitaized. next you could try creating a variable and then using that for the password.

Code:

dim pass as string
pass = "Test"
 
ActiveSheet.Unprotect Password: pass

That didn't work for me either.

Tags

password, remove password

« Previous Thread | Next Thread »

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 05:32 AM.