View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oxicottin oxicottin is offline
external usenet poster
 
Posts: 26
Default message box when file is opened

Hello I have been serching around in this forum and dont really understand
how to do this. I want a pop up message to open when an .xls file is opened.
I did find someone wrote this. But I dont know how to do this I never messed
with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!!

putn the following code in yopur workbook module ('ThisWorkbook'):
sub workbook_open()
msgbox "Now opening..."
end sub