Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone help with this? See the code below.
Assuming that the "*********" is the correct password to open LiceseFile, why does the password prompt come on screen when this macro is running? Clicking cancel (without entering a password) cancels the prompt and the macro continues to open the file correctly. Application.DisplayAlerts = False Application.ScreenUpdating = False Range("LicensePath").Select LicenseFile = Selection.Value On Error GoTo NoLicenseFile Workbooks.Open FileName:=LicenseFile,Password:="*********" Thanks for whatever help you can provide. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Excel password but cant hide the sheets before entering password | Excel Programming | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |