G Guest Apr 27, 2005 #1 I'd like to set a macro so that when the file is opened, it automatically runs.
B Bob Phillips Apr 27, 2005 #2 Put the code in the Workbook_Open event in the Thisworkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) kanye said: I'd like to set a macro so that when the file is opened, it automatically Click to expand... runs.
Put the code in the Workbook_Open event in the Thisworkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) kanye said: I'd like to set a macro so that when the file is opened, it automatically Click to expand... runs.
G Guest Apr 27, 2005 #3 I've located the Thisworkbook code module, but see nothing about Workbook-Open event. Where do I look for this?
I've located the Thisworkbook code module, but see nothing about Workbook-Open event. Where do I look for this?
J JulieD Apr 27, 2005 #4 see my response to the question you posted 1 min before the one Bob answered .... titled "Automatic Message"
see my response to the question you posted 1 min before the one Bob answered .... titled "Automatic Message"
B Bob Phillips Apr 27, 2005 #5 Input this into the Thisworkbook code mould Private Sub Workbook_Open() End Sub and add your code to it. -- HTH RP (remove nothere from the email address if mailing direct) kanye said: I've located the Thisworkbook code module, but see nothing about Workbook-Open event. Where do I look for this? Click to expand... automatically runs.
Input this into the Thisworkbook code mould Private Sub Workbook_Open() End Sub and add your code to it. -- HTH RP (remove nothere from the email address if mailing direct) kanye said: I've located the Thisworkbook code module, but see nothing about Workbook-Open event. Where do I look for this? Click to expand... automatically runs.
