un/protecting VBA project
 

Hi all

Does anyone know whether it is possible to un/protect a
VBA project, e.g. something like:

ActiveWorkbook.VBProject.Protect Password:="X"
(doesn't work for excel97)

Thanks in advance!

un/protecting VBA project
 

Hi Claude,

Does anyone know whether it is possible to un/protect a
VBA project, e.g. something like:

ActiveWorkbook.VBProject.Protect Password:="X"
(doesn't work for excel97)


No, not possible, unless you use the (unreliable) SendKeys method.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

un/protecting VBA project
 

Sendkeys is the only way other than manually.

--
Regards,
Tom Ogilvy

"Claude" wrote in message
...
Hi all

Does anyone know whether it is possible to un/protect a
VBA project, e.g. something like:

ActiveWorkbook.VBProject.Protect Password:="X"
(doesn't work for excel97)

Thanks in advance!