View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Rename Module via VBA

While running:

Sub rename_it()
ThisWorkbook.VBProject.VBComponents("Module1").Nam e = "new_check"
End Sub

I get a "1004" error

"Programmatic access to Visual Basic Project is not trusted"

I feel that i have earned the trust of my computer and my own files.

How do I avoid this error.

p.s. I can still re-name a module manually in the editor.

--
Gary's Student