HELP WITH MACRO

Place this under your normal module :

sub auto_open()
msgbox="your text"
end sub

is this what are you looking for

bye

I'M GETTING A COMPILE ERROR. "FUNCTION CALL ON LEFT HAND SIDE OF ASSIGMENT MUST RETURN VARIANT OR OBJECT" KNOW WHY?

Luigi,

Remove the equal sign (=) from the Msgbox call. It should read:

MsgBox "whatever message you want here"

enjoy

: I NEED HELP CREATING A MACRO THAT WILL DISPLAY A MESSAGE EVERYTIME THIS ONE WORKBOOK IS OPEN. IS THIS POSSIBLE?

Remove the equal sign (=) from the Msgbox call. It should read: MsgBox "whatever message you want here"
IT WORKED. THANK YOU! : bye :