You're welcome.

It was a bugger to get working right and I wound up on no less then 10 forums ... doing god knows how many google searches ... trying to figuring it out myself.

I am a VBA novice too be sure ... was quite the eye opener.

It all started with a 20 + sheet workbook that I created for all my properties to submit invoices and get approvals. I lock all the worksheets/cells with the exception of a couple of data/date/cost/description cells. Helps to prevent our property managers from messing up all the formulas and calculations.