Reminder to be flagged up when closing file
Reminder to be flagged up when closing file
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Reminder to be flagged up when closing file

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way in a file I can set up for a reminder to be flagged up when someone closes a file, so it reminds them to have done something?

    I have never used Visual Basic so I have no idea how to use it, so I am looking for another way of doing this that is not VB?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Seattle Area, WA
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    if you use the auto_close macro, everytime the workbook is closed it will do this procedurce weither it is to save the file, always return to a specfic cell, etc.

    You can also have it pop up a message box to alert the user as you said....

    try using the msgbox command.


    Russell

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