| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Visual Basic Protection and Delete Modules
I have in my visual basic the following code
' Deletes Modules Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") vbCom.Remove VBComponent:= _ vbCom.Item("Module2") vbCom.Remove VBComponent:= _ vbCom.Item("Module3") vbCom.Remove VBComponent:= _ vbCom.Item("Module4") This macro is held in module 8 and when the code is ran it works if visual is unprotected but give run-time error 50289: can't perform operation since the project is protected when the visual is protected. How do I run this macro with visual protected? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visual Basic Protection and Delete Modules
You are going to have difficutly with that one. You can not execute teh code
with the project locked and there is no truely effective way to unlock it... check out the paragraph just above the bright red warning... http://www.cpearson.com/excel/VBE.aspx -- HTH... Jim Thomlinson "Jeremy" wrote: I have in my visual basic the following code ' Deletes Modules Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") vbCom.Remove VBComponent:= _ vbCom.Item("Module2") vbCom.Remove VBComponent:= _ vbCom.Item("Module3") vbCom.Remove VBComponent:= _ vbCom.Item("Module4") This macro is held in module 8 and when the code is ran it works if visual is unprotected but give run-time error 50289: can't perform operation since the project is protected when the visual is protected. How do I run this macro with visual protected? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visual Basic Protection and Delete Modules
The interesting thing is the hint about SendKeys. I actually tried that
approach a few weeks ago and got it to work (interesting security hole) in Excel 2003 and even 2007 on Windows XP systems. However, there was an issue in the way that the SendKeys were being handled in Excel 2007 on a Vista system and I couldn't achieve the same effect (granting permission to access the VBA Project) in that setup; the last keys needed to complete the sequence didn't end up getting sent to the ribbon control as needed. "Jim Thomlinson" wrote: You are going to have difficutly with that one. You can not execute teh code with the project locked and there is no truely effective way to unlock it... check out the paragraph just above the bright red warning... http://www.cpearson.com/excel/VBE.aspx -- HTH... Jim Thomlinson "Jeremy" wrote: I have in my visual basic the following code ' Deletes Modules Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") vbCom.Remove VBComponent:= _ vbCom.Item("Module2") vbCom.Remove VBComponent:= _ vbCom.Item("Module3") vbCom.Remove VBComponent:= _ vbCom.Item("Module4") This macro is held in module 8 and when the code is ran it works if visual is unprotected but give run-time error 50289: can't perform operation since the project is protected when the visual is protected. How do I run this macro with visual protected? Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visual Basic Protection and Delete Modules
So is it possible for me to delete modules with visual being locked and how?
Thanks "JLatham" wrote: The interesting thing is the hint about SendKeys. I actually tried that approach a few weeks ago and got it to work (interesting security hole) in Excel 2003 and even 2007 on Windows XP systems. However, there was an issue in the way that the SendKeys were being handled in Excel 2007 on a Vista system and I couldn't achieve the same effect (granting permission to access the VBA Project) in that setup; the last keys needed to complete the sequence didn't end up getting sent to the ribbon control as needed. "Jim Thomlinson" wrote: You are going to have difficutly with that one. You can not execute teh code with the project locked and there is no truely effective way to unlock it... check out the paragraph just above the bright red warning... http://www.cpearson.com/excel/VBE.aspx -- HTH... Jim Thomlinson "Jeremy" wrote: I have in my visual basic the following code ' Deletes Modules Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") vbCom.Remove VBComponent:= _ vbCom.Item("Module2") vbCom.Remove VBComponent:= _ vbCom.Item("Module3") vbCom.Remove VBComponent:= _ vbCom.Item("Module4") This macro is held in module 8 and when the code is ran it works if visual is unprotected but give run-time error 50289: can't perform operation since the project is protected when the visual is protected. How do I run this macro with visual protected? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
| How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
| How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
| Delete Code Modules Programatically | Excel Discussion (Misc queries) | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Hybrid Mode
