Pop Ups

[Fraggs]

I've seen some spreasheets where when you open it, a kessage box appear
and says "something". How is this achieved? I'm really new to VB b
the way so make it as simple as you can please

 

[DSC]

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

 

[Fraggs]

That exactly what I was looking for, thanks

 

[Bob Phillips]

Sub Auto_Open()
MsgBox "Hello", vbInformation
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)