Prevent user disabling events
 

I have created an excel 97 spreadsheet containing certain
sensitive information that I wish to protect to some
degree.

On opening the spreadsheet locked down userforms appear
under the workbook_opn vba routine. I have also protected
my VBA code and disabled the break key etc within it.

My final hurdle is that when excel is opening the user can
hold down shift and bypass my auto open, I believe the
shift sets enableevents to be false.

Is there away around this, can I disable the shift key,
bearing in mind that this spreadsheet would be used by
networked users - so I cant alter their windows registry.

Thanks

Prevent user disabling events
 

No. Protection schemes based on macros are practically useless. And to
expand, protection schemes based on the protection offered in an Excel
workbook are practically useless.

--
Regards,
Tom Ogilvy
"JP Farrow" wrote in message
...
I have created an excel 97 spreadsheet containing certain
sensitive information that I wish to protect to some
degree.

On opening the spreadsheet locked down userforms appear
under the workbook_opn vba routine. I have also protected
my VBA code and disabled the break key etc within it.

My final hurdle is that when excel is opening the user can
hold down shift and bypass my auto open, I believe the
shift sets enableevents to be false.

Is there away around this, can I disable the shift key,
bearing in mind that this spreadsheet would be used by
networked users - so I cant alter their windows registry.

Thanks