Sheet protection

[Valerie]

I have a spreadsheet that will be shared across a network
for salespeople to use for quoting jobs. The sheet is
protected so that the original formulas and information
cannot be changed, but the salespeople will be inputting
job-specific data. Individual quotes will be saved
as "Q0001, Q0002" and so on. Is there a way to track
changes made to the "Q" files? My fear is that the
salespeople may do a "save as" and then make the changes
they want to modify the quote file.

Thanks.

 

[Bill Lunney]

You could try catching the BeforeSave event and do something there. Perhaps
write some info to a log file or similar. If my understanding of this is
correct there may be other possible solutions. I'll let other posters pick
up on these.

http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=184


--
Regards,


Bill Lunney
www.billlunney.com