I have 15 Worksheets that contain personal data from each organization, I am
having a brain lock here cause I done something simular with my budget that
when you open the file it ask for a password but I need to protect each sheet
indivdually.

What is happening is when i protect the worksheet with a password then I
select another sheet then go back I see the personnal information I don't
want them to see the data until a password is provided for the corresponding
worksheet.

Any help would be appreciated to include if there is a macro that you can
point me to I am not good with VBA but I do understand some of it.

I will be eventually moving this to a SharePoint site with user level
protection, with the individuals I work with I have to start at the lowest
form and develop upwards.

Thanks
--
Robb