Hi Jamie,

I am not sure what "run the dialog box" means!

If you want to activate a specific sheet each time that the workbook is
opened, try the suggested code.

If you want to run a specific macro each time that the workbook is opened,
try something like:

'=============
Private Sub Workbook_Open()
Call MyMacro '<<==== CHANGE
End Sub
'<<=============

If this does not assist, please explain in more detail your intentions.

---
Regards,
Norman



"Jamie13" wrote in
message ...

Hey Norman Thanks, I have done this however it still doesn't auto load
the "run the dialog box" when the excel workbook is opened. This is my
main aim! Any more help would be greatly appreciated!

Thank you!


--
Jamie13
------------------------------------------------------------------------
Jamie13's Profile:
http://www.excelforum.com/member.php...o&userid=33175
View this thread: http://www.excelforum.com/showthread...hreadid=529952