Welcome Screen, Macro to Save, Print?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
Click to expand...
screen? Below is code for splash screen
 
Back
Top