Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to understand how macro will write the password in VBAmby using recording Macro for a protected password workbooks, because I am trying to make a link base on the example 1 of Mr. Ron De Bruin, but I can not see the VBA of the password itself: Here is the VBA of my recording: Sub testh() ' ' testh Macro ' Ini adalah untuk mengetest kalau pakai password ' ' Keyboard Shortcut: Ctrl+Shift+H ' ChDir "\\Admin-hdd\budget-contr\BUDGET CONTROL M\BUDGET 2009" Workbooks.Open Filename:= _ "\\Admin-hdd\budget-contr\BUDGET CONTROL M\BUDGET 2009\M10-9-006 ASAHI.xlsx", _ UpdateLinks:=0 End Sub Thanks for any help. Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
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 |