Use multiple passwords to protect different ranges of cells in a worksheet

Absolute novice but wanting to use one spreadsheet with various ranges of cells to be available for editing to different groups. I understand all the responses regarding ease of getting past this level of protection but this is more than suitable for my needs and as I'm starting out would like to get a basic understanding of how this works before I go gallumping off - I am absolutely certain that the folks using the spreadsheet are even less excel savvy than I am.

I have no idea of how to write a macro instructing if password entered is A unlock this range of cells to edit and if password entered is B unlock this range of cells to edit etc. - nor do I have any idea of how to get a macro active in a sheet - long way to go!

Please keep this really simple - I'm hoping someone will come up with a very simplistic way of explaining the structure/language of a macro so I can put together - first macro - be gentle.

This is your first macro so try recording your macro first..
And explain in brief & attach the sample file showing before result and after result...
This will help us to understand more

There's no need for a macro for this as Excel has a built-in way of doing it. What you're looking for, if I understand you correctly, is setting up ranges for users to be allowed to edit. I'm currently using Excel 2003 (blame my employers!), where it's under 'Tools > Protection > Allow Users to Edit Ranges'. In 2010, which I use at home, I think 'Allow Users to Edit Ranges' is on the 'Review' tab, in the 'Changes' group - I think 2007 is the same.
You can then select different ranges and give them different passwords. The ranges can overlap or not.
Attached is a file with 8 ranges set up - I've just left the default names, but you'll normally want to name them something useful.

The MS online help for this feature is here:
https://support.office.com/en-US/art...__toc296590752

Hope that helps.