Here's what I need some help with....
Have created a form in Excel that consists of cells in the first 7 rows are
a combination of locked and unlocked cells for the users entries. There are
also 9 rows at the bottom that are also locked and unlocked. Everything in
between these two areas needs to be unprotected so the user can make text
entries or combine cells to insert an object (graphic, chart or other). I
have created a toolbar with buttons that allow the user to unlock the
worksheet to have access to tools and processes they normally would not with
the sheet locked as well as another button that allows them to relock the
worksheet (yeah, like they are really gonna do that).

Is there a way to add code to the lock / unlock buttons that will relock the
two ranges at the top and bottom if the user clicks into either of these two
areas? Assistance as always, is greatly appreciated.

Regards - Lenny