Prevent user disabling events

  • Thread starter Thread starter JP Farrow
  • Start date Start date
J

JP Farrow

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How disable an Excel dialog box? 4
Preventing workbook_open code executing. 2
Disable functions on command bar 1
Prevent user moving the userform with mouse 2
Prevent disabling of macros? 3
Can we require "Enable Macros" or else the file can't be opened? 2
Disable the PauseBreak key 4
Windows key and keycode 4

Back
Top