Error trapping and branching in a sub routine

I have the following macro attached to my 2007 Excel spreadsheet (is it a macro or VBA?) which is an audit form. The core of the procedure works fine (with no little help from my friends on this forum) but as certain values in the spreadsheet will need to be reviewed on a yearly basis (Budget Day!) I need to ensure that the rates hard-coded into the form are current (by resetting the tax rates and/or the review date) The review date is held in cell F132 and is hidden from the user.

How do I include a test with branch and label to exit the routine with an error message "Review Required" when the if the current DATE() is > than the date in F132 without performing any other statements in the routine (and does F132 have to have a specific date format)? I need to ensure the spreadsheet is still protected if the "Review Required" message has been issued

Please Login or Register  to view this content.

thanks

Andy

The date format in F132 doesn't matter

Please Login or Register  to view this content.

AlphaFrog

That's absolutely perfect for what I want though it's a completely different approach to what I was expecting.

Sorry I missed you last night (time zones!) - thanks very much for your help and prompt reply

Andy