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
