Disable "shift" key

[ruadangyeu]

hello everybody!
I have a MS excel application, it has a startup form
I want disable "shift" key when workbook_open

please help me!
thanks

[Marcster]

I don't think this is possible in Excel.

You could hide all interesting sheets, protect the workbook and VBA
project so that if a user opens the workbook with
macros disabled, they won't be able to do much with it.

Check the following KB entry on how to do this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=578

HTH

Marcster.

[Bob Phillips]

Not wholesale, but what are you specifically trying to stop, there may be other ways.

[ruadangyeu]

Thanks
I think we can't disable "shift" key when workbook open
because "shift" key disable workbook_open, auto_open event

have a nice day

[Charlize]

Thanks
I think we can't disable "shift" key when workbook open
because "shift" key disable workbook_open, auto_open event

have a nice day
That's why we hide every sheet xlveryhidden the first time you close (with before close) the workbook exept an intro sheet. Next time on opening in workbook_open unhide every sheet and hide introsheet.

Introsheet has message to inform that macros must be enabled to work with your workbook.

Charlize