Untested, but I'd try:
AddIns("RollForm").Installed = False
AddIns("RollForm").Installed = True
If that doesn't work, then maybe it is a timing issue.
You could use:
AddIns("RollForm").Installed = False
AddIns("RollForm").Installed = True
Application.OnTime Now + timeSerial(0,0,1), "Continue_Open"
End Sub
And the put the remainder of the code in that Continue_Open in a General module.
On 06/22/2010 13:57,
wrote:
In the ThisWorkbook module of a spreadsheet I have the statement:
AddIns("RollForm").Installed = True
The next line calls a sub in RollForm.xla.
The call fails because RollForm.xla is not yet loaded. If I step through
the code, it works fine.
How can I program a wait for RollForm.xla to be loaded?
Thanks!
--
Dave Peterson