Thread: Pop Ups
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DSC[_3_] DSC[_3_] is offline
external usenet poster
 
Posts: 1
Default Pop Ups

If it is A password then you can save the workbook as passwor
protected

or else use VBA to write a message box in the workbook_Open Event.

If you want to do this

right click the picture next to the file menu item
choose view code
change the first drop down box to workbook

and then type

msgbox "This is my Text"

every time you open the workbook the messagebox appears

Hope this helps

Davi

--
Message posted from http://www.ExcelForum.com