Hi,

I posted a problem yesterday and had a very prompt solution so I'm hoping for a similar result with this one.

I have been tasked with providing perfomance measurements for a team of six but all the info is to be kept private from the other team members.

So if Officer1 wants to see what their success rate is they can check there stats but not be able to see the stats for Officer2 and so on.

I have found a code on here to protect a worsheet form being opened unless you have the correct password but I want to be able to copy this so that each Officer worksheet can only be accessed by them with their password of choice.

I'm not very cultured when it comes to VBA so any help is appreciated


HB Suspend 2012 - 2013.xlsm