view code in excel sheets
 

Hi all

When you want to run a macro for a certain sheet continously you righ
clight the sheet tab and then click on view code and insert the macr
there.

Is there an equivalent for word documents and in fact is it possible t
have a macro run when ever word opens?

Thank

--
jim2

-----------------------------------------------------------------------
jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=31985

view code in excel sheets
 

Open a word document

macros for word works exactly same as excel

goto - tools-macro-visual basic editor, double click "this document
below project (file name)

paste this code

Private Sub Document_Open()
MsgBox "document opened"
End Su

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=31985