Autorun macro

[boon kian]

Hi, The situation is like this: I have created a MCQ test using a excel spreadsheet and I have created a nice macro GUI which will display the "time left" and will save and close the application which the time is up. May I noe how can I prog the macro to run automatically when the spreadsheet is opened ? Please advise. Thank you !! With regards bk

[Edbert P]

Why don't you call the macro in the spreadsheet auto macro called Workbook_Open()? Therefore it will always be called when the spreadsheet is opened.