Disable shift from ignoring autoexec

[njwiz]

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

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

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

Thank

 

[Guest]

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

 

[Randy Hudson]

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

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

Edwin is probably correct that you can't, and shouldn't, be able to keep
users from blocking auto-open macros. But you can "flag when the workbook
is opened with the shift key held": have the flag set, and clear it in the
Auto_Open (Workbook_Open) Sub. If it doesn't get cleared, your Open routine
didn't run.

It's not really secure, of course; but it's better than nothing.

 

[Guest]

Randy,

I have an unrelated problem with my right shift key. Whenever I press it, the page switches to, apparently, my set home page. I've tried to find what I have done to make this hapen but haven't found it yet. You see, I am physically impaired, in a wheelchair ten years, and what is happening looks very much like some of the things you can do with the disabilities features in Windows. Help? (e-mail address removed)

 

[Dave Peterson]

This sounds like it's outside excel.

Guess#1:
In win98, I can do:
windows start button|settings|Control panel|accessibility options.

There's nothing like this setting in win98, but maybe something was added in
your version of windows.

Guess#2:
Do you have any third party software that's helping? Maybe hitting alt-ctrl
delete to see what's running will spark your memory.

Guess#3:
Some keyboards are programmable. (Gateway, for example.) Maybe you have that
programmed into the keyboard?