Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 occurs only in specific cases
Hi experts,
a simple macro that is executed on the start of Excel generates an - at least for me - puzzling effect. The macro is part of a workbook which is in the folder XLStart, so it will be opened every time Excel is started. When I start Excel directly it works perfectly well without any problem. Whenever I start Excel indirectly by opening any other workbook, then I get the error 1004, specifying that Excel can't execute the first line of the macro ("Method 'Calculation' of the object 'Application' does not work"). These are the first lines of the macro: With Application .Calculation = xlCalculationManual .MaxChange = 0.001 End With Call CreateMenu Windows("Personl.xls").Visible = False ThisWorkbook.Sheets("Menu_Blatt").Visible = xlVeryHidden Do you have any hints how to prevent this effect (except never starting Excel indirectly... ;-) )? Thanks in advance Udo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Cases=144 * # of Cases + Pieces | Excel Discussion (Misc queries) | |||
count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
MsgBox when an Error occurs | Excel Discussion (Misc queries) | |||
formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Auto_add not called, but not found error occurs | Excel Programming |