[mso] Re: Excel 97 ?
- From: Carr <carr_kids@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 28 Sep 2002 14:03:27 -0700 (PDT)
Hello,
Thanks Linda and Anthony for your suggestion of using a macro. I just got back
in town. I'll give this a try once I get back to work on Tuesday.
Linda,
I'll be checking in on the messageboard at some point this weekend. Right now
I'm playing catch up.
Thanks,
P.
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
---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
*************************************************************
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:
