EXCEL 2003 VB

D

Donna C

I am trying to put a simple message box that will appear when Excel is opened
to a new blank workbook.If they answer yes, then run my macro/module in that
workbook.If they answer no, then the message box closes and they have a blank
workbook.
 
B

Bob Phillips

If the book is blank, how can you run a macro in it?

Do you want this to happen for every new workbook?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
D

Donna C

I'm sorry, I meant the macro will be stored in the personal workbook on the
departments computer. So, I am guessing that it would be better to only
present the message box in a particular workbook that would be used for the
project, like a workbook titled "Uniwest".Then if yes is answered to running
the macro/module it would run on the next blank page.
Thank you ahead of time
Donna C.
 
Top