at the top menu beside File, there is an excel symbol, right click on
that icon and select view codes,
Now at the drop down menu where it says general, drop down the menu to
select -workbook
go to the next drop down menu and select -open
beginning and ending code appears
put your copy and paste your macro between these two lines of code
for example purposes
popy and paste this code in between those two lines


Dim Msg As String

Msg = "This is Dave's great WorkBook!!"
MsgBox Msg

it will end up looking like this


Private Sub Workbook_Open()
Dim Msg As String

Msg = "This is Dave's great WorkBook!!"
MsgBox Msg
End Sub
Once you have that right then practise butting in the code from your
macro
Dave


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516505