Welcome Screen, Macro to Save, Print?

[Guest]

Hi
1) Anyway to create welcome screen with pop-up message when open a file
2) How to create macro for print
3) How to create macro for save
4) How to create macro to save & print
Thanks.

 

[Frank Kabel]

Hi
1: http://j-walk.com/ss/excel/tips/tip39.htm
2. - 4. Try recoding a macro while doing this manually. To give you the
ides:
sub print_it()
activesheet.printout
end sub

sub save_it()
activeworkbook.save
end sub

 

[Guest]

Hi, Mr.Frank Kabe
I try the code, it works fine and I feel very happy
Is there any way to include user name on the splash screen? Below is code for splash scree
----------------------------------------------------------------------------------------------
1. Insert the following subroutine into the code module for the ThisWorkbook object

Private Sub Workbook_Open(
UserForm1.Sho
End Sub

2. Insert the following subroutine into the code module for UserForm1:
Private Sub UserForm_Activate(
Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm
End Sub

3. Insert the following subroutine into a normal VBA module:
Private Sub KillTheForm(
Unload UserForm
End Su


----- Frank Kabel wrote: ----

H
1: http://j-walk.com/ss/excel/tips/tip39.ht
2. - 4. Try recoding a macro while doing this manually. To give you th
ides
sub print_it(
activesheet.printou
end su

sub save_it(
activeworkbook.sav
end su

-
Regard
Frank Kabe
Frankfurt, German

 

[Frank Kabel]

Hi
you have to add some code to the userform initialization
(add the username in this procedure). To be honest
Userforms are not my area of expertise (I'm always happy
if Bob or Tom provide some solutions for this)

But I think on the site I provided to you there's also
some explanantion about doing this kind of stuff

-----Original Message-----
Hi, Mr.Frank Kabel
I try the code, it works fine and I feel very happy.
Is there any way to include user name on the splash

screen? Below is code for splash screen