Help about saving changes

[Rekx]

First of thanks to everyone on this board for helping me out the last couple of days. You all are very friendly and soooo knowledgable about Excel...I wish there was something I had to offer.

Well, in the last couple of days I am very proud to have created this spreadsheet with the help of this message board;

reporting check sheet.xls
	A	B	C	D	E	F	G	H
1	Client	Rpts.Required	DateChecked	Current?	MissingDocument	Action	ActionLetterSent	SpecialCommentsFromClient
2	ACG	Shipments	2/20/2004		jhgjyg	hgfghf		None
3
4	ACMInc.	Shipment	2/20/2004		Current	Current		None
5		Bulk	2/20/2004		Current	Current		None
6		Storage	2/20/2004		Current	Current		None
7
8	AlexanderInternational	Storage	2/20/2004		Current	Current		None
9	AmericanPortServices	Storage	2/20/2004		Current	Current		None
10
11	AremiDistrubuidora	Shipments	2/20/2004		ytu	tyuty		None
12		Storage	2/20/2004		Current	Current		None
13
14	BruceAlbrightAgency	Storage	2/20/2004		Current	Current		None
15		Bulk	2/20/2004		Current	Current		None
Sheet1

When you hit, say, the "Shipment Update" command button, it automatically inserts the current date, asks if they are current, selects the correct button, and asks what documents are missing and what actions where taken etc and inputs them into the appropiate field.

My question is, is it possible for excel to record on a seperate sheet each change or update made for each client and all the info that was changed. For instance, for the client ACG at the top,I already have a link to another page, and I would like a history of each update kept on that page.

Is this possible? Thanks for your help.
-Adam

 

[Rekx]

I have followed all the instructions by Andrew and Greg but it is not making any changes to the "Track" sheet. Not sure what I'm doing wrong here.

 

[Greg Truby]

You mentioned that you got an error from the Undo. That's after the Application.EnableEvents=False statement. Try going to your Immediate window and typing ? Application.EnableEvents If that returns FALSE then that's your problem. Just type Application.EnableEvents=True in the Immediate window and then try again.