[mso] Re: Excel 97 ?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 11 Sep 2002 13:18:45 -0400
Cool, Anthony. I figured this would be a pretty simple macro and this
should give P what she wants, right P?
The only time this wouldn't work, I guess is if she opened the workbook
and saved it without making changes, but why would she do that?
So...I'd say this should do it!
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Colli, Anthony G
Sent: Wednesday, September 11, 2002 1:13 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Excel 97 ?
Linda p-
I have had a chance to do some Excel programming lately. I don't know
of a
way to detect changes in an entire workbook that have not been saved,
but
this macro will display the last time the workbook was saved, and will
display that value every time the workbook is opened.
Private Sub Workbook_Open()
Application.ActiveWorkbook.ActiveSheet.Cells(1, 1).Value = "Last Save"
Application.ActiveWorkbook.ActiveSheet.Cells(2, 1).NumberFormat =
"m/d/yy
h:mm AM/PM"
Cells(2, 1).Value = BuiltinDocumentProperties("Last save time")
End Sub
-Anthony
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
