Microsoft Office Forums - View Single Post - Removing a password from a worksheet

Thread: Removing a password from a worksheet

View Single Post

Old

11-20-2013, 12:44 AM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

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

Reply With Quote