| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
| Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
| How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
| Protecting a VBA project | Excel Programming | |||
| Protecting a VBA project | Excel Programming | |||
Linear Mode
