PDA

View Full Version : Enabling Macros



Rick Clark
05-15-2006, 05:29 AM
I have a spreadsheet that is used buy 50 plus people. It is a template that uses VBA to control many command buttons and check boxes. Each user has it loaded on thier laptops and all are using excel 2003.

It is pass code and protected as well as what can be. If it is loaded without enabling the macros I have noticed that the buttons and check boxes can be move around the sheets even thought it it is passcode. The problem with this is it is set up the way it is because it produces a legal document and it is important to keep the positioning of these check boxes.

How can I force them to load this with the macros enabled or not at all? I remember seeing some place some thing on this but like all great things, when you need it, you can't find it. lol

This is the last thing that is holding up distrubuting it. If anybody can help me, it will be greatly appreciated.

Thanks

lucas
05-15-2006, 05:36 AM
Hi Rick,
Here are a couple of entries that address your problem. Maybe you can find a start there. I would suggest searching the excel part of the kb for the word "force" for more entries including passwords...

http://vbaexpress.com/kb/getarticle.php?kb_id=379

http://vbaexpress.com/kb/getarticle.php?kb_id=578