View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default 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