MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA KeyPress

Posted by Mindy on August 28, 2001 8:08 AM

I have a Excel file with the macro. The macro will be executed when the file open. Now, I am looking for keypress event on the file opens. I don't want the icon on the worksheets. Will it be possible to have key press even to call and execute the workbook_open event?

Any suggestion or comments will be real helpful. Thank you for the time and help.


Posted by Mindy on August 28, 2001 8:31 AM

Just find the answer. I can use application onkey event to do it.
Thanks anyway.