Select Options in the Tools dropdown menu in the toolbar
at the top of the Excel window, in the Options dialog box
that appears click in the check box by "Prompt for
workbook properties".

The way this works is, workbook properties actually only
become properties after they have been entered and saved.
So, MS has set this prompt to only appear when a new file
is saved for the first time.

This means that after setting this in the Options, when
you open a new file save it immediately and the Properties
dialog box will open automatically after you have typed in
the name of the file and clicked on the Save button.

I don't know how to show the Properties dialog box using
VBA yet.

-IA
-----Original Message-----
Hi

Is there anyway of having the properties dialog box open
up automatically
when starting a blank spreadsheet? The box I refer to is
accessed nomally
from the File / Properties on the menubar.

Thanks

Steve


.