FROM THE VISUAL BASIC EDITOR. IN THE PROJECT PANE ON THE LEFT CLICK ON THIS
WORKBOOK (ASSUMING YOU ONLY HAVE ONE PROJECT OPEN). IN THE RIGHT HAND PANE
YOU SHOULD HAVE A COUPLE OF DROPDOWNS CHANGE THE FIRST FROM (GENERAL) TO
"WORKBOOK" AND THE SECOND TO "OPEN". PUT YOUR CODE IN WORKBOOK_OPEN SUB AND
THAT SHOULD DO IT.

"RyanMMurphy" wrote:


If anyone is still checking this post. Another quick question. Is there
a way to make this macro run when the spreadsheet is opened? The logic
behind it has changed a little bit. I got it working to meed the
changed requirements but if possible it would be great to have it run
when the spreadsheet opens.

Thanks for any and all help.

Ryan


--
RyanMMurphy
------------------------------------------------------------------------
RyanMMurphy's Profile: http://www.excelforum.com/member.php...o&userid=33453
View this thread: http://www.excelforum.com/showthread...hreadid=532608