View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Udo Udo is offline
external usenet poster
 
Posts: 48
Default Change in action when converting to *.xla

Hi experts,

there is a simple starting macro which runs fine when the file which
contains it is started separately:

Sub kick_off()
Windows("Help and aid.xls").Visible = False
ThisWorkbook.Sheets("Menu_Sheet").Visible = xlVeryHidden

With Application
.Calculation = xlManual
.MaxChange = 0.001
End With

Call CreateMenu

Application.ScreenUpdating = True

End Sub

When I convert it to an *.xla and start it from the Add-In-Manager, it
just generates an error message and doesn't do anything.

How can I cope with that?
Udo