If this data is really sensitive, then don't put it into your excel file.

Worksheet protection is easily broken.

Keith wrote:

Hi,

I have a spreadsheet that, when opened it checks who the user is then
hides specific rows based on the user. Unfortunately I have two problems

1. If they Select Disable Macros then they can see the whole
spreadsheet. How can I make it so that if they disable then the
spreadsheet just closes?

2. Once the routine has run and the rows are all hidden how do I stop
users just dragging the rows back out, or selecting an group then
selecting unhide?

Any help would be greatly appreciated.

Thanks

Keith

--

Dave Peterson