Hi All,
I need to lock (VBA Project) my destination workbook with password. But i dont want to use the sendkey option.
Please advice on the below question?
I have the current workbook with macro. I moved some sheets from current workbook to the destination workbook. now i want to lock the vba code in the destination workbook through my current workbook.
I have to send the workbook to my customer.
Last edited by sethu_bala1; 09-16-2013 at 03:21 AM. Reason: Extra information
Please Login or Register to view this content.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
Hi, sethu_bala1,
any reason for not using Right Click in the Project Explorer and proceeding from there since you are talking about the VBA-Project to lock in your workbook. Keep a copy of the workbook without lock or note the password in a safe place (not an Excel workbook).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks