• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro Protection

A

amitc4u

Member
Hi,
I have a file containing a Macro that I don't want people that using the file to see or copy.
I would like people to be able to use the file and all the macro commands (by using designated operation buttons in the sheets), make changes, save, delete and perform all the operations but without seeing the code in the VB.

thanks,
Amit
 
@amitc4u
Press ALT + F11 on the excel workbook that contains the macro
Click on the VBA Project in VBA Project window
ALT + T + E
Now click on the "Protection" tab of the pop up
Ensure that "Lock Project for Viewing" is checked
Then type the password below on the same pop up and confirm the same..and click ok..save the file...and close..
Now reopen the file if you wish to double check..(recommended)
 
Quick note, "protection" <> "secure", ie encrypted. With enough time and effort, VB projects can be accessed. Just wanted to say in case information is highly sensitive.
 
You must log in or register to reply here.
Back
Top