![]() |
EXTREMELY slow toolbars?
We have a toolbar we create in code, so that it can be customized on a
worksheet-by-worksheet basis. When a sheet is opened, by clicking on the tabs, the code examines the toolbar, removes any existing buttons, and replaces them with the correct ones for that sheet. When this code first runs, it is extremely fast. The entire process of deleting the existing buttons, looping over a list to see which ones are needed, and then adding them back takes well under a second. However, this process slows down. Today it is taking about 4-5 seconds to do the same thing. There have been no data changes at all. The "solution" so far is to use the Toolbars... editor to delete the toolbar and let the code re-draw it from scratch. This works for a day or two before it slows down again. Does anyone know what's going on, and how to fix it? Maury |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com