Hi Neil,

You can't totally protect if the client is serious about seeing what is in
the columns.
It is hard to advise without knowing all of the facts surrounding the
workbooks so the following is really only me thinking aloud of possibilities.

Is the data in the hidden columns required for the clients copy or is it
possible that these columns could be cleared? If the data in the hidden
columns is used in formulas on visible parts of the worksheet, what about
copy - paste special - values before clearing the hidden columns.

--
Regards,

OssieMac


"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.