Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put password for excel file in VB code
Hello,
I open two new work books named as work book 1 and work book 2. i feed some data in work book 1 and in work book i used one formula that is =A1 from work book 1 and enter that value entered in work book. if put password for work book 1 and save it and after that i open work book 2 that file ask update link or password to open the file. i just want to ask the question is can it possible i put my password in VB code because when i open my excel file that time never ask for password.or i protect my only my VB coding. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put password for excel file in VB code
Hi, Try this Workbooks.Open "C:\book2.xls", Password:="MyPass" Mike "NANA" wrote: Hello, I open two new work books named as work book 1 and work book 2. i feed some data in work book 1 and in work book i used one formula that is =A1 from work book 1 and enter that value entered in work book. if put password for work book 1 and save it and after that i open work book 2 that file ask update link or password to open the file. i just want to ask the question is can it possible i put my password in VB code because when i open my excel file that time never ask for password.or i protect my only my VB coding. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
macro code to change file-opening password | Excel Programming | |||
Include password in VBA code to open file problem | Excel Programming | |||
Include password in VBA code to open file problem | Excel Programming |