Prevent Excel 2007 Image appearing on opening

[adam]

Hi Anyone,

I don’t know whether this might be possible in excel 2007, but just thought of asking.
Anyway my question is that; could the appearing of what is shown in the image be prevented through a VBA code so that it does not appear as the Excel 2007 opens for the particular workbook.

Any suggestion or help on this would be kindly appreciated.

Excel 2007.jpg

[rory]

No, since the workbook is not open at that point.

[stuck]

But you can disable the splash screen by adding the '/e' switch to your Excel shortcut:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

Ken

[HansV]

If you're willing to open that particular workbook from a shortcut, it can be done. Create a shortcut with as Target:

"C:\Program Files\Microsoft Office\Office12\Excel.exe" "H:\Excel\MyWorkbook.xlsx" /e

substituting the path to Excel.exe and the path and name of the workbook.

[adam]

Thanks for the help guys. I do really appreciate that.