HELP WITH MACRO
Posted by LUIGI on November 25, 2001 11:06 AM
I NEED HELP CREATING A MACRO THAT WILL DISPLAY A MESSAGE EVERYTIME THIS ONE WORKBOOK IS OPEN. IS THIS POSSIBLE?
Posted by NiuB on November 25, 2001 11:18 AM
Place this under your normal module :
sub auto_open()
msgbox="your text"
end sub
is this what are you looking for
bye
Posted by LUIGI on November 25, 2001 11:35 AM
I'M GETTING A COMPILE ERROR. "FUNCTION CALL ON LEFT HAND SIDE OF ASSIGMENT MUST RETURN VARIANT OR OBJECT" KNOW WHY?
Posted by Bariloche on November 25, 2001 11:47 AM
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?
Posted by LUIGI on November 25, 2001 1:04 PM
Remove the equal sign (=) from the Msgbox call. It should read: MsgBox "whatever message you want here"
IT WORKED. THANK YOU! : bye :
