alk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of stonesfan
Sent: 27 June 2012 9:55
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Message Box to Show
ActiveSheet.PageSetup.Orientation
I need to trap PageSetup settings to determine if
I need to trap PageSetup settings to determine if the active worksheet can
be printed programmatically.
(Note that I'm not asking how to change them - if they are not within
reason, the active sheet will not be printed.)
I thought the following line of code would result in "xlPortrait" or
"xlH
vbCrLf & txt
MsgBox txt
End If
End With
End Sub
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prashant
Envoyé : samedi 11 juin 2011 08:31
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Message bo
MsgBox txt
End If
End With
End Sub
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prashant
Envoyé : samedi 11 juin 2011 08:31
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Message box- for Reminder of Due date
Dear Experts,
I need help on macro. I need message box to pop up when file is opened.
And Message box should show code & name for employees where return
date=today. Attached file for reference
Regards,
Prashant
--
-
Hi,
I need to insert a message box in the middle of a macro that will
request the user to enter a "Start Date" or give them the option to
skip it and
let the macro continue running. Any help would be deeply appreciated.
Thanks,
Steve
--~--~-~--~~~---~--~~
-
