Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Template Double Click behavior / action | Excel Discussion (Misc queries) | |||
How to change action of double-click left mouse button? | Excel Discussion (Misc queries) | |||
Cell change causes action | Excel Programming | |||
Evaluate cells for change and then action | Excel Programming | |||
Automating a date field to change on certain action | Excel Programming |