The only way I know is by physically removing the shift keys from the users' keyboards.

I don't think a way to do that (to disable the effect of holding the shift key and force-execute macros) is in the design specification of MS Office.

If there is a way to do that, I would immeidately recommend my company and my clients to stop using MS Office until a security patch has been release by Microsoft. The integrity, reliability and confidentiality of critical company data and documents are at high risk and you'll see this in the news headline soon. We'll also immeidately look for substitue of MS Office as part of our contingency action.

Also, in a few days, you'll see computer viruses demonstrating how to make full use of that feature in practice.


----- njwiz wrote: -----

When opening a Excel 2000 or Excel 2002 workbook, holding a shift key
will disable the auto open macro.

Does anyone know a way to disable the shift during my initial process
or perhaps there is a way to flag when the workbook is opened with a
shift key held?

There must be a way to do this so that I can lock my application down.

Thanks


---
Message posted from http://www.ExcelForum.com/