Turn off an Initialized Class

macropod · #2 05-01-2017, 04:03 PM

Quote:

Originally Posted by ilcaa72

hello, i have an this sub that initializes a Class event that runs code on any change of the selection. I wanted to assign a Macro button to "turn off" the event.

Whats the proper VBA to 'de-initialize' the event?

There is no facility to do that. Either put your event code into a template that applies only to documents based on that template - so it doesn't affect documents based on other templates - or add some error trapping to ensure the event exits unless the document or selection conforms to certain specifications.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I would like a function to add sequential numbers to a class number/name	Highlander01	Excel	5	01-22-2016 02:29 PM
Is it possible to bind macros to keys not in the KeyCodeConstants class?	AlexR	Word VBA	4	04-08-2013 10:15 AM
Evernote--Class Notes	markg2	Outlook	0	05-10-2012 05:50 PM
Looking for easy and quick way to draw on class notes "x-rays - image"	Lacrosseboss18	PowerPoint	0	02-04-2011 01:21 PM
Want to search for "class", replacing with document property	YetAnotherAuthor	Word	0	10-30-2009 09:43 AM