need VBA code to allow user to expand/collapse columns but still protect the cells...

Hello All,

I am in a bind. This is my code.

Please Login or Register  to view this content.

The situation is that I would like user to expand and collapse the grouped columns. The code above works great. however the issue is that when they enter their "password", they also have access to the formulas in the cells and have the ability to edit/delete the cells in the worksheet they are accessing. This is what I am trying to protect. Protect all the cells in the worksheet but allow the users to expand and collapse the grouped columns only. I should mention that the worksheet is already protected with worksheet password but sheet1 is unprotected when the user enter "password".

Can someone help?

Thanks!