T TraciLea Aug 22, 2008 #1 When an excel spreadsheet is opened, can I have a custom message pop-up for other users? It is for documentation control.
When an excel spreadsheet is opened, can I have a custom message pop-up for other users? It is for documentation control.
D Dave Peterson Aug 22, 2008 #2 Option Explicit Sub Auto_Open() msgbox "Hi from TraciLea" End sub If you're new to macros: Debra Dalgleish has some notes how to implement macros here: http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.)
Option Explicit Sub Auto_Open() msgbox "Hi from TraciLea" End sub If you're new to macros: Debra Dalgleish has some notes how to implement macros here: http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.)
