thanks for all your help guys! -Prizeless!!
Now, I really want to make some sort of a welcome/startup box/screen to inform the user on how my sheets are set up.
Any good ideas?
Sincerley yours, Andreas.
thanks for all your help guys! -Prizeless!!
Now, I really want to make some sort of a welcome/startup box/screen to inform the user on how my sheets are set up.
Any good ideas?
Sincerley yours, Andreas.
Last edited by abrunstad; 03-02-2009 at 09:59 AM.
Hi,
you can use the Workbook_Open event to force something to happen whenever the workbook is opened.
Hit Alt-F11 to open the VBA Editor, then double click on ThisWorkbook and enter your code in the code window. You could either do a message box as per code below, or go to a specific tab in the worksheet that has your info. The latter might be easier to maintain.
code for showing a message box:
code for navigating to Sheet1Private Sub Workbook_Open() Dim msg As String msg = "This workbook is used to do bla bla bla bla." & Chr(10) msg = msg & "It consits of several sheets bla di bla di bla" & Chr(10) msg = msg & Chr(10) msg = msg & "more information for the user bla bla" & Chr(10) msg = msg & "and some more text." MsgBox msg End Sub
Hope this helpsPrivate Sub Workbook_Open() Sheets("Sheet1").Select Range("A1").Select End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks