MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Password Problem


Posted by ecnirp on February 04, 2002 7:28 AM

I am linking one excel spreadsheet to another, using copy/pastespecial link. The file i am copying from is password protected on read/write, but i need to copy 3 cells from the sheet which are not sensitive (its a payroll spreadsheet). I know the password, but if anyone else uses the spreadsheet it prompts for the password. Is there anyway i can pass the password through automatically so the links work without prompting for the password.

Thanks in advance.


Posted by Carl B on February 04, 2002 8:30 AM

Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.

Syntax

expression.Unprotect(Password)

expression Required. An expression that returns a Chart, Workbook, or Worksheet object.

Password Optional Variant. A string that denotes the case-sensitive password to use to unprotect the sheet or workbook. If the sheet or workbook isn't protected with a password, this argument is ignored. If you omit this argument for a sheet that's protected with a password, you'll be prompted for the password. If you omit this argument for a workbook that's protected with a password, the method fails.

Remarks

If you forget the password, you cannot unprotect the sheet or workbook. It's a good idea to keep a list of your passwords and their corresponding document names in a safe place.

Posted by ecnirp on February 04, 2002 11:08 AM

How do you mean :

expression.unprotect(password)

is expression a reserved command in VB?

Paul.

Posted by ecnirp on February 04, 2002 12:14 PM


Hi

This is an example of the macro i'm running, when i run the macro, the password protected file prompts for the password :

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 04/02/02 by paul
'
' Keyboard Shortcut: Ctrl+a
'
Workbooks.Open FileName:="E:\work systems\package levels.xls"
End Sub

So where should i put the .Unprotect(Password)expression then, i presume before i open the file?

Paul