Wizard
11-04-2005, 09:59 AM
I have a spreadsheet that has probably over 100 ActiveX buttons (added from the Controls menu, not the Forms menu), spread over a dozen worksheets.
The spreadsheet takes forever to load, save or close (2m30s, 0m45s, & 1m15s respectively), mostly while showing no progress whatsoever in the status bar. While it has a lot of macros in it, the file itself is not that large (4.4Mb) since it is a repository of macros & procedures, not data.
Could all those ActiveX buttons be weighing down the start & shutdown process to that extent? Would switching over to the "Forms" variety of button speed things up?
Thanks!
The spreadsheet takes forever to load, save or close (2m30s, 0m45s, & 1m15s respectively), mostly while showing no progress whatsoever in the status bar. While it has a lot of macros in it, the file itself is not that large (4.4Mb) since it is a repository of macros & procedures, not data.
Could all those ActiveX buttons be weighing down the start & shutdown process to that extent? Would switching over to the "Forms" variety of button speed things up?
Thanks!