Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start up window
I am using Excel 2003. Every time I start Excel, I get a pop up window with
the title Microsoft Visual Basic. The message in the window says "File not found". What is the cause and how can it be avoided? Also my Excel program is set to open up with my Personal Macro Workbook open but hidden, which is how I would like it. Every time I exit from Excel, I get a window that asks if I want to save changes to your Personal Macro Workbook. I then have to wait for some some before it reconfigures itself. Can I avoid this? Thanks very much, Ricki |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start up window
Use the Application.DisplayAlerts = False
to rid of the prompt to Save. Sounds like you Personal Macro cannot find the Workbook it is looking for, or another i would check this macro for what it is looking for. Corey.... "Ricki Miles" wrote in message ... I am using Excel 2003. Every time I start Excel, I get a pop up window with the title Microsoft Visual Basic. The message in the window says "File not found". What is the cause and how can it be avoided? Also my Excel program is set to open up with my Personal Macro Workbook open but hidden, which is how I would like it. Every time I exit from Excel, I get a window that asks if I want to save changes to your Personal Macro Workbook. I then have to wait for some some before it reconfigures itself. Can I avoid this? Thanks very much, Ricki |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start up window
Sounds like you may have a volatile formula in the Personal.xls, such as
=TODAY(). When a workbook opens with a volatile formula, the workbook is marked as dirty, so you will be asked to save it when it closes. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ricki Miles" wrote in message ... I am using Excel 2003. Every time I start Excel, I get a pop up window with the title Microsoft Visual Basic. The message in the window says "File not found". What is the cause and how can it be avoided? Also my Excel program is set to open up with my Personal Macro Workbook open but hidden, which is how I would like it. Every time I exit from Excel, I get a window that asks if I want to save changes to your Personal Macro Workbook. I then have to wait for some some before it reconfigures itself. Can I avoid this? Thanks very much, Ricki |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what row do I start an address for a window envelope? | Excel Discussion (Misc queries) | |||
configuration window at start | Excel Discussion (Misc queries) | |||
Excel window not maximized on start | Excel Discussion (Misc queries) | |||
How to auto start a new Excel image or window when opening files | Setting up and Configuration of Excel | |||
default (start-up) window size | Excel Programming |