message

  sms 16:18 03 Jul 2007
Locked

I would like to create an opening message when an excel worksheet opens and then let it close after a time limit. Any ideas please

  VoG II 16:41 03 Jul 2007

Create a Userform with a Label containing your message.

In the Visual Basic Editor, right click This Workbook and select View Code. Copy and paste in

Private Sub Workbook_Open()
UserForm1.Show vbModeless
Application.Wait (Now() + TimeValue("00:00:03"))
Unload UserForm1
End Sub

Save and close the workbook then reopen it to see your message.

"00:00:03" pauses for 3 seconds - change that and the name of the UserForm to suit.

  sms 09:49 04 Jul 2007

Hi Vog

Copied your details into User Form as described, but nothing happened. Set up user form with Label.
Can you advis please

  VoG II 10:13 04 Jul 2007

The code has to go in the ThisWorkbook code module. Also the file needs to be saved as an .xlsm file so that macros are enabled.

If you would like to send me a message via my yellow envelope I can send you an example file.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017