After much work ... and surfing the net ... I was able to put together the following solution.
The code can be placed into one module and then saved as an "Add-In" in your Add-in folder for Office within your "
c:\Documents and Settings\[username]\Application Data\Microsoft\AddIns\[file-name.xla"
Once installed as an add-in it will automatically load each time you start excel ... it will dock itself to the left of the "Formatting Toolbar" and unload when you exit Excel.
The protect macro will prompt you for a password ... set all the sheets to only allow access to unprotected cells ... and lock every sheet in the active workbook.
The unlock macro will unlock all the sheets in your active workbook no matter how many you have so long as you provide the correct password.
Lastly,
You can add other macros to the toolbar if you desire.
Hope this saves others all the time and effort I went through working this out.
Bookmarks