Fairly Advanced Problem
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Fairly Advanced Problem

  1. #1
    Guest

    Default

     
    I want to add a windows style prompt that will apear when a wookbook is opened. It will need to read something along the lines of "Stop Press and then list my special offer" the person that has opened the work book will have to click OK before they can continue to use it... How do I do this?

  2. #2
    Guest

    Default

    Private Sub Workbook_Open()
    MsgBox "Put your message here"
    End Sub

  3. #3
    Guest

    Default

    I still can't get this to work. I take it I write this as a macro? Help!

  4. #4
    Guest

    Default

    Put it in the ThisWorkbook code module.

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi


    Right click on the Excel icon (top left next to File) and select "View Code"



  6. #6
    Guest

    Default

    My limited Excel knowledge is failing me.
    Can you tell me how to do this step by step?
    I am good with macro's and have a fairly good working knowledge of the programme but I am being really thick on this occasion.

  7. #7
    Guest

    Default

      
    Done it - Made it work! Thank you.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com