Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My project adds a worksheet to the active workbook and then adds a shee
change event procedure at run time. After the procedure is ran, th vbe window automatically opens to the new sheet change event procedure Is there a way to prevent this from happening? I have tried turnin off screen updating and adding the line VBE.MainWindow.Close to the en of the code, but I get the error "Programmatic Access to Visual Basi Project is not Trusted." I have signed my project and selected "Trus access to Visual Basic Project" in the macro security settings and still get the error. I am using Excel 2002 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet Change Event - copy cell to another sheet | Excel Discussion (Misc queries) | |||
Excel Bi-weekly time sheet change dates to Thursday- Wednesday? | New Users to Excel | |||
Cancel sheet change event | Charts and Charting in Excel | |||
Sheet Name Change Event? | Excel Programming | |||
Sheet Name Change Event? | Excel Programming |