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

Rename Module via VBA
 

Works by me!

HTH
--
AP

"Gary''s Student" a écrit dans le
message de news: ...
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

Rename Module via VBA
 

Excel 2002 added a new security setting was added whereby you must grant
access in order to manipulate objects that are part of the VBProject with
VBA.


From the menu Tools/Macro/Security, select the Trusted Sources tab and check
"Trust Access to Visual Basic Project".


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Gary''s Student" wrote in message
...
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

Rename Module via VBA
 

You need to change your macro security settings as follows:

Menu Tools Macro Security... tab Trusted publishers tick 'Trust
access to VBA projects'

Cheers


Gary''s Student schreef:

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

Rename Module via VBA
 

You need to change your macro security settings as follows:

Menu Tools Macro Security... tab Trusted publishers tick 'Trust
access to VBA projects'

Cheers

Gary''s Student schreef:

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

Rename Module via VBA
 

Thank you
--
Gary''s Student


"Bob Phillips" wrote:

Excel 2002 added a new security setting was added whereby you must grant
access in order to manipulate objects that are part of the VBProject with
VBA.


From the menu Tools/Macro/Security, select the Trusted Sources tab and check
"Trust Access to Visual Basic Project".


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Gary''s Student" wrote in message
...
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

Rename Module via VBA
 

Thank you
--
Gary''s Student


"Joost Lenaerts" wrote:

You need to change your macro security settings as follows:

Menu Tools Macro Security... tab Trusted publishers tick 'Trust
access to VBA projects'

Cheers

Gary''s Student schreef:

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