credit where credits due

  • hi I have spent months refining a workbook for use at work, and other people are asking me for a copy, which i am happy to give. However, some of them may claim it is then their work..
    ....so
    ...is there a way of incorporating some code so that whenever the workbook opens a popup window pops up with appropriate details so they know I made it


    ...even better would be a dialog box, where they have to click "ok" to a message to continue


    thanx in advance
    dave

  • To add to Smitty's answer (hi Smitty! !wave!)


    You may want to password protect your project else some of the more VBA savvy users may be able to remove the message.


    In the VBE right click on your project (something like VBAProject(yourworkbookname.xls)) and choose 'Properties'. Choose the Protection tab and check the 'Lock project for viewing' and pop in a password.


    Another option could be to have a locked worksheet with a text box containing your message


    HTH

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • You could also try hiding the window.


    Private Sub Workbook_Open()
    Application.Windows.Item(1).Visible = False
    If MsgBox("I created this", vbOKCancel, "Creator") = vbOK Then
    Application.Windows.Item(1).Visible = True
    Else
    Application.Quit
    End If
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!