un/protecting VBA project

C

Claude

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!
 
J

Jan Karel Pieterse

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)
Click to expand...

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

Regards,

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