ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Callback to Excel (xlcOnTime) and worksheet renaming (https://www.excelbanter.com/excel-programming/368131-callback-excel-xlcontime-worksheet-renaming.html)

[email protected]

Callback to Excel (xlcOnTime) and worksheet renaming
 
Hi all,

I'm writting an XLL add-in for Microsoft Excel

I found in microsoft forum that a way to have a callback in Excel is to
schedule a function with Excel4(xlcOnTime, ...). It works great for me
except in one situation.

I put some traces in my callback function to be sure that it is called.
When I start Excel, all is ok, I can see the traces. In fact, all is
ok as lons as I don't rename a worksheet. It seem that when I'm
renaming a worksheet, the callback timer stops.

Do you have any idea on how to solve this problem?

Thanks a lot.

Nic



All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com