Norman is absolutely correct. What you are doing is running an even
procedure, which is a bit complicated to explain. An event procedur
runs when something happens (in your case, the workbook being opened)
It must be put in the correct place (i.e. the workbook section o
code).

I did notice that your post had WorkbookOpen as the name of th
routine. An event procedure for opening the workbook would be calle
Workbook_Open (notice the underscore). The easiest way to check fo
what event procedures are available is to go to the specific code are
(either a worksheet or the workbook) and click on the left-most dro
down at the top of the screen. In the ThisWorkbook module, if yo
select Workbook from the left drop down, it will give you all of th
events that are associated with the workbook.

Post back with more questions.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26661