Martin Brown;613260 Wrote: [color=blue]
DS wrote:
It can't be that. I have a number of generic spreadsheets that will
run
on any version of Excel and all are password protected. You may have
to
put them in a trusted location and adjust trust centre settings
accordingly, but XL2007 will permit password protected macros to run.


Hi Martin,

thanks for your response. It does seem that it *is* that, though it
seems as though it's not a consistent issue. I've never come across it
before in any flavour of OS / Office combination. The Trust Centre was
the first thing I checked.

I tried the following with the wb in question, making no other
changes:
Password present - no code will run.
Remove Password - code will run fine.
Re-add password - no code will run
Remove Password - code will run fine
Add R/W Password - code will run fine in both Read Only and full access
modes.
Add full password - no code will run
Remove all passwords - code runs fine


I've found an article by Ron deBruin about the matter. His method of
dealing with it involves registry editing to allow the password / code
run to remain together, and notes that it isn't consistent.
'Macros are disabled when you open password protected workbooks'
(http://www.rondebruin.nl/password2007.htm)

Cheers,
MikeC


--
MikeC
------------------------------------------------------------------------
MikeC's Profile: 1386
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170364

Microsoft Office Help