Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling messages from Project
I run a macro from Excel to extract information from MS
Project files and write to a Word document. The MS Project files contain macros and a reference to a common MS Project Resource sheet. How do I disable the Macro and Open Resource Pool dialog boxes from appearing for each MS Project file that I open? I have: 1) Application.ScreenUpdating = False at the start of the macro which disables the screen updates in Excel 2) wdAPP.Visible = False after I start Word to disable screen updates there 3) prAPP.Visible = False & prAPP.DisplayAlerts = False when I start MS Project I still get 2 prompts for each MS Project file I open. Am I missing something? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hyperlinks - disabling warning messages | Links and Linking in Excel | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Pop up messages | Excel Programming | |||
Messages not available | Excel Programming |