Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003 VB
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003 VB
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) "Donna C" <Donna wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2003 VB
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. "Bob Phillips" wrote: 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) "Donna C" <Donna wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |