Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming to VBE
There is no support for that for obvious reasons (prevent a brute force
attack on the password). The only work around I have seen posted in these groups is to use sendkeys which would be risky to say the least. -- Regards, Tom Ogilvy "Ajit" wrote in message ... I am working on a situation where there are couple of hundred excel templates with forms , modules etc. And i need to make a global change in the code to one of the procedure. I found some valuable information at www.cpearson.com which helped me pragramme to the Visual basic editor. What i am doing is : I am opening the required template, finding the procedure which needs to be replaced , deleting that procedure and adding a new procedure with same name but different code. All works well....except when VBE project is protected. Could someone suggest a wayout to unprotect the project at runtime ...make the required changes and then again protect the project before saving it. Suggestions will be highly appreciated. Thanks -- Ajit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming | Excel Discussion (Misc queries) | |||
programming help | Excel Discussion (Misc queries) | |||
Programming help | Excel Discussion (Misc queries) | |||
Programming Help | Excel Programming | |||
Do I need programming for this? | Excel Programming |