View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keithlo Keithlo is offline
external usenet poster
 
Posts: 62
Default Security and working with VBComponents

My macro fails at this code:

With WB.VBProject.VBComponents(2).CodeModule
..DeleteLines 1, .CountOfLines
End With

In my macro security, I do not have the "Trust access to visual basic
project" checkbox checked. But even if that is the right thing to do, can
anyone tell me what this line of code is doing? Is it deleting the VB code
from the workbook "WB"?

Thanks,

Keith