Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming |