Posted to microsoft.public.excel.programming

Adam[_14_] Adam[_14_] is offline

external usenet poster

Posts: 4

Disabling worksheet_change when running a specific macro . .

Never mind . . . Should've spent more time googling before posting that
.. . .
Fixed it with

sub InsertProj
Application.EnableEvents = False
<< Code
Application.EnableEvents = True
end sub

on my macro . .

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Disabling WORKSHEET_CHANGE event	Jase	Excel Discussion (Misc queries)	1	April 25th 08 04:32 PM
Disabling a specific macro	Matt	Excel Programming	3	December 9th 05 03:03 AM
Worksheet_Change Event triggered off specific cell	ExcelMonkey[_142_]	Excel Programming	2	June 7th 04 03:33 AM
worksheet_change vs. calculate, and worksheet_change not running	Tom Ogilvy	Excel Programming	1	July 14th 03 02:51 AM
worksheet_change vs. calculate, and worksheet_change not running	Ross[_5_]	Excel Programming	0	July 13th 03 04:27 PM

All times are GMT +1. The time now is 08:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us