delete module
 

I am having trouble deleting modules. I am used to this working, even
though it looks like I am deleting worksheets and not modules. It does not
work, however, on new program/computer, for some reason:
Sheets(Array("module2", "module3")).Delete

These 2 do not work either:
Modules(Array("module2", "module3")).Delete
WorkSheets(Array("module2", "module3")).Delete

I have tried Chip Pearson's routine, but couldn't get it to work, either.
"Programmatic access to Visual Basic Project is not trusted" is what I get.

Does anyone know of a way to simply delete modules? Thanks, Mike Allen

delete module
 

You need at least to grant programmatic access to delete modules

ToolsMacroSecurity and on the Trusted Publishers tab, tick the Trust
access to Visual Basic project checkbox. Then follow the instructions on
Chip's site.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"mike allen" wrote in message
...
I am having trouble deleting modules. I am used to this working, even
though it looks like I am deleting worksheets and not modules. It does not
work, however, on new program/computer, for some reason:
Sheets(Array("module2", "module3")).Delete

These 2 do not work either:
Modules(Array("module2", "module3")).Delete
WorkSheets(Array("module2", "module3")).Delete

I have tried Chip Pearson's routine, but couldn't get it to work, either.
"Programmatic access to Visual Basic Project is not trusted" is what I
get.

Does anyone know of a way to simply delete modules? Thanks, Mike Allen