View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Udo Udo is offline
external usenet poster
 
Posts: 48
Default 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