LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default Class stops working

Class stops working...

Some time ago on Dick Kusleikas Daily Dose of Excel (dicks-glob.com) a
utility for putting additional stats on the status bar was posted. With that
idea in mind, I created a Class Module to show the sum and count of selected
ranges on the status bar so that you don't have to continuously switch
between them.
To keep the status bar updated, in the class module, I use€¦
App_Stats_SheetActivate
App_Stats_SheetSelectionChange
App_Stats_WorkbookBeforeSave

The problem is:
Every so often, the Class Module stops working and the status bar no longer
updates. I cant pin down whats going on when it stops working because I
only look at the status bar when I need the sum/count information€¦and then
notice that its not giving me the information. I have another Class Module
that also depends on specific events such as SheetActivate that also appears
to stop working at the same time.

Does anyone have any idea why a class module might stop working and yet
macros in Standard Modules continue to work? And, of course, do you know how
to get around this issue? I dont know if Im going down a blind alley but
it appears that macros that I specifically call work fine while macros
dependent on an event stop.

Any help would be greatly appreciated.

Thanks in advance.
Sincerely,
Gary Brown



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF just STOPS WORKING Gee Excel Worksheet Functions 21 August 6th 09 05:26 PM
Vlookup stops working??? Steve Peel Excel Worksheet Functions 0 September 19th 08 07:08 PM
VB Code stops working Michelle K Excel Programming 17 August 17th 07 05:58 PM
Autofilter Stops Working Vliegveld Excel Worksheet Functions 7 September 7th 05 01:19 AM
VBA Stops Working? Marty Excel Programming 4 February 16th 05 05:27 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"