Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Editor module
I have written a VBE module that indicates the last saved date to th footer on a particular workbook. Can someone tell me how I can move/edit/re-write so that this can b used for ALL workbooks? thanks in advance, Marc ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Editor module
Hi
I use this in every workbook I want to use this(in the Thisworkbook module) When you print the footer will be updated before it print.(not working correct in 97) Maybe somebody else can help you with a good way to have it available in all your workbooks. Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ActiveWindow.SelectedSheets wkSht.PageSetup.RightFooter = "&8Last Saved : " & _ ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") Next wkSht End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "soopial" wrote in message ... I have written a VBE module that indicates the last saved date to the footer on a particular workbook. Can someone tell me how I can move/edit/re-write so that this can be used for ALL workbooks? thanks in advance, Marcy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Editor module
See Chip Pearson's discussion of application level events:
http://www.cpearson.com/excel/AppEvent.htm -- Regards, Tom Ogilvy "soopial" wrote in message ... I have written a VBE module that indicates the last saved date to the footer on a particular workbook. Can someone tell me how I can move/edit/re-write so that this can be used for ALL workbooks? thanks in advance, Marcy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA editor | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
VB Editor | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |