If there is data in an excel file that a recipient shouldn't see, then excel is
not the right container for it.

Excel's protection is to try to stop users from writing over formulas (and minor
stuff like this). It's not made for the kind of protection that you would need.

The password to unprotect a worksheet is easily broken.

If you have to put the sensitive data into excel, then don't share with others
who shouldn't see it.

Neil Holden wrote:

Hi Gurus, I have an excel sheet which is a master document that all users use.

Once a user has completed the relevant fields in this excel sheet I have
created a macro which is a button, when pressed it will save as and the user
then chooses where to save it too, after that the macro will hide certain
columns so that clients cannot see the hidden colums and save as again:

1. One excel sheet for our own viewing
2. Another for clients.

The issue which i have which is a major issue is the clients can un hide the
columns but the trouble i have is that the clients will need to edit certain
cells so I can't password protect the entire workbook.

Please help.

Neil.

--

Dave Peterson