Visual Basic Protection and Delete Modules
in [General]
|
From: Jeremy on 26 Apr 2010 11:23 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
From: Jim Thomlinson on 26 Apr 2010 13:11 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
From: JLatham on 26 Apr 2010 14:34 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
From: Jeremy on 27 Apr 2010 09:32 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
|
Pages: 1 Prev: Using Formatted Text with AutoCorrect in Excel Next: Viewing Tabs |