change event

duckfoot · May 1st, 2002, 06:22 AM

what is a worksheets change event?

s-o-s · May 1st, 2002, 06:27 AM

A change event is any change that occurs in a spreadsheet.

You can assign some macro code to run as soon as a change event is discovered.

UHsoccer · May 1st, 2002, 08:23 AM

Sending a spreadsheet to a customer, could I use that to "record" (in that sheet) that a change was made?

If so how do I do so and can it be dated and "hidden"?

PS, We sent quotes and sometimes it gets returned to us with changes made to it (without being told). It becomes a mess later on to prove that the change was made at the customer site, rather than by us...

lenze · May 1st, 2002, 08:29 AM

UHsoccer:

You can do that with Tools>Track Changes.
See Help for more info

May 1st, 2002, 06:27 AM	#2
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	A change event is any change that occurs in a spreadsheet. You can assign some macro code to run as soon as a change event is discovered. __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 06:22 AM	#1
duckfoot New Member Join Date: Apr 2002 Posts: 22	what is a worksheets change event?

May 1st, 2002, 08:23 AM	#3
UHsoccer Board Regular Join Date: Apr 2002 Location: Detroit Posts: 792	Sending a spreadsheet to a customer, could I use that to "record" (in that sheet) that a change was made? If so how do I do so and can it be dated and "hidden"? PS, We sent quotes and sometimes it gets returned to us with changes made to it (without being told). It becomes a mess later on to prove that the change was made at the customer site, rather than by us...

May 1st, 2002, 08:29 AM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	UHsoccer: You can do that with Tools>Track Changes. See Help for more info