Prev: Excel 2002: Can I not overwriting non blank destination cells ?
Next: Excel file slow
From: Donald Dudar on 13 Mar 2010 11:06
I am tryinig to create a popup or other type of information sheet for users
to read instructions on how to use a print macro I have created in a
worksheet. I would like to have this appear as soon as the worksheet opens,
so all users can have the information.

I seem to recall there is a way to creat this funcitonality.

I appreciate any assistance anyone can offer.

Thanks

Don
From: Don Guillett on 13 Mar 2010 11:21
Look in the SHEET module for sheet activate

msgbox "do this"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Donald Dudar" <DonaldDudar(a)discussions.microsoft.com> wrote in message
news:2419F9D8-E237-49DA-B80F-73107CA53164(a)microsoft.com...
>I am tryinig to create a popup or other type of information sheet for users
> to read instructions on how to use a print macro I have created in a
> worksheet. I would like to have this appear as soon as the worksheet
> opens,
> so all users can have the information.
>
> I seem to recall there is a way to creat this funcitonality.
>
> I appreciate any assistance anyone can offer.
>
> Thanks
>
> Don

From: FSt1 on 13 Mar 2010 12:01
hi
create a form and use lable controls to type your instructions.
then use the workbook open event to show the form on file open.
Private Sub Workbook_Open() 'goes in this workbook module
Load userform1
userform1.Show 0
End Sub
the 0 (zero) at the end of line userform1.show 0 displays the form as
modeless meaning that the user can leave the form open but still do work on
the sheet.
you could put a close button on the form.
Private Sub CommandButton1_Click()
Unload Me
End Sub

or use the form close "X" at the upper left of the form.
see this site on how to set up a userform.
http://contextures.com/xlUserForm01.html

regards
FSt1


"Donald Dudar" wrote:

> I am tryinig to create a popup or other type of information sheet for users
> to read instructions on how to use a print macro I have created in a
> worksheet. I would like to have this appear as soon as the worksheet opens,
> so all users can have the information.
>
> I seem to recall there is a way to creat this funcitonality.
>
> I appreciate any assistance anyone can offer.
>
> Thanks
>
> Don
 | 
Pages: 1
Prev: Excel 2002: Can I not overwriting non blank destination cells ?
Next: Excel file slow