View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Change in action when converting to *.xla

Change ThisWorkbook to Activeworkbook. Thisworkbook refers to the addin,
Activeworkbook refers to the active workbook (couldn't think of a better way
to say that <vbg).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Udo" wrote in message
oups.com...
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