Solved

protect vba

Posted on 2011-02-15
3
284 Views
Last Modified: 2012-05-11
Hi,

With EEs help, my vba script is working.  I need to release this to my coworks to use.  Since there will be more than one person, I want to lock the code.  I have two questions:
1. Once the password is applied, the button is disabled, why is that?
2. Where can I enter password to unlock it?  thx
0
Comment
Question by:mcrmg
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 34897473
Which button is disabled?

0
 

Author Comment

by:mcrmg
ID: 34897488
I have a button on the sheet1 that trigger a function..thx
0
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 34897586
Can't be anything to do with the password.

Are you sure you have macros enabled or are running in a trusted location?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now