Before save event macro

[certain_death]

Hi all

can someone help please?

I want a macro event that when the user presses save, it gives them a message box that says "please colour completed lines in yellow".

I dont want any condition attached to it, I want the message box to appear regardless.

Please help,
Many thanks
**

[snb]

Why don't you colour those lines using VBA ?

[certain_death]

I want user to have the control, and then by colouring it in notifies other users that the data is final.

[snb]

Then I'd prefer an indication in the workshet, not when saving (do not bother users with - mostly unnecessary - messages).

[certain_death]

well thats what I want it to do..I dont want an indication. Its more of a reminder