G
Guest
While running:
Sub rename_it()
ThisWorkbook.VBProject.VBComponents("Module1").Name = "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.
Sub rename_it()
ThisWorkbook.VBProject.VBComponents("Module1").Name = "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.