Excel: Disable Shift+ Open...

[Pcfred]

Just curious. I don't want to password protect the file.
Is there anyway of preventing someone from disabling the Auto_open macros while opening an excel workbook.

 

[woja]

Don't think so.

The [tt]Shift+Open[/tt] option allows people to open files they may suspect are "rogue" (with viruses, etc.) so that they don't execute the [tt]Autpen[/tt] macro.

Personally, if I couldn't open an Excel sheet in this manner, I'd suspect (even if my suspicion is wrong) that someone is trying to do a dirty on me (I'm not saying that's what your are trying to do; I'm just saying I'd be suspicious).


[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[TonyJollans]

Hi Pcfred,

You can't disable the macro bypass, but you can make your workbook (almost) unusable if your macros don't run (have all but one empty sheet veryhidden, etc). This has been discussed several times here and you should find something if you do a search.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[xlbo]

Tony - have just discovered a flaw in that plan as in XP you can set the hidden property from xlveryhidden to visible manually by going to the properties section of the VBE - You now need to password protect the VBProject as well to stop users from being able to change the visible property of the sheets

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[TonyJollans]

Hi Geoff,

You always could do that. The point is that the change can only be made via code or the VBE, the (average) User cannot do it. And password protecting the VBA Project doesn't stop anyone using the Immediate window to run code.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[xlbo]

sorry Tony - I was under the impression that in '97, you couldn't change the visible property to visible from the VBE if the sheet was xlveryhidden - thanks for the info

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244