If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Protecting VBA code in excel

UsedtobePC · 2007-08-29 10:08:01

does anybody know how to prevent people from accessing and/or modifying VBA code behind a macro? I've written an Excel model for work and now i have to roll it out to the business but I don't want people messing with it and certainly don't want people being able to copy the code. Thanks in advance guys

29-08-2007 10:08am

#1

UsedtobePC

Closed Accounts Posts: 114 ✭✭

Join Date: August 2006

Posts: 102

does anybody know how to prevent people from accessing and/or modifying VBA code behind a macro?

I've written an Excel model for work and now i have to roll it out to the business but I don't want people messing with it and certainly don't want people being able to copy the code.

Thanks in advance guys

0

Comments

#2 29-08-2007 10:47am

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

One thing springs to mind that might be possible - Could you compile the Macro code into an ActiveX dll and reference that from Excel? This would achieve both goals for you.

0
#3 29-08-2007 10:51am

Gosh

Registered Users, Registered Users 2 Posts: 683 ✭✭✭

Join Date: October 2004

Posts: 654

In the Project Explorer view right click on the VBAProject item and click on VBAProject Properties, click on the Protection tab, check the 'Lock Project for Viewing' and enter a password below. Make sure you save after doing this and the code will not be visible to anyone without knowing the password.

0
#4 30-08-2007 9:00am

UsedtobePC

Closed Accounts Posts: 114 ✭✭

Join Date: August 2006

Posts: 102

That's just exactly what I needed. Thanks a mil!

0
#5 30-08-2007 9:58pm

rasoul

Closed Accounts Posts: 86 ✭✭

Join Date: November 2005

Posts: 74

It is though, very simple to run a macro that hacks the VBA password.

0