Mike... did you ever find out what to do to be able to run macros on a
password protected workbook? Would appreciate your help before I go crazy!

Roger.


"mike" wrote:

sry for the off topic Samantha . . .

I was using 2007 when I found that my macro wouldn't run on a protected
workbook. It took me days to figure out what was goin wrong and several hours
in this forum - No one was able to help me.

"Gord Dibben" wrote:

Mike

Is this a feature of Excel 2007?

In earlier version. macros will run on protected workBOOKS


Gord Dibben MS Excel MVP


On Tue, 24 Jun 2008 13:41:01 -0700, mike wrote:

In my experience, if you protect the workBOOK, macros will not run. They
should still run with a protected worksheet though.

"Samantha" wrote:

Is there any way to make macros work once my document is protected? If so how?