RE: Two Excel questions -- PCTECH

Dan,

In reverse order:

2) Hit F2 -- does that do what you need?

1) I don't know a way to do it in the "Page Setup" part of Excel, but
that's not to say it can't be done. Bring up the VB Editor in Excel. Add
the code below to the WorkBook object. If you want this there by default
save this as Book.xls in ...\Application Data\Microsoft\Excel\XLStart.
The code will reset the RightHeader (use what you want) to be the Last
Save Time before each print. When you first bring up a new book this
time will be the time you saved the template, after that it will be the
time you saved this book.

Private Sub Workbook_BeforePrint(Cancel As Boolean)

ActiveSheet.PageSetup.RightHeader = BuiltinDocumentProperties("Last Save
Time").Value

End Sub

-Walden 


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Dan Bale
Sent: Friday, August 27, 2004 9:35 AM
To: pctech@xxxxxxxxxxxx
Subject: [PCTECH] Two Excel questions

Excel 2000 (on W2K)  (BTW, can anyone suggest helpful Excel web sites
that
have tutorials and useful forums?)

1) I have a personal habit of printing the date & time on the printed
output.  In Word, I have always been able to specify the file date/time,
which is more meaningful than the current date/time that the document
was
printed.  In Excel, I have only been able print the current date/time.
Does
anyone know if it's possible to print the file's save date/time in the
header or footer?

2) There are two methods that I am aware of to edit a cell.  The first
is
when the cursor/focus is in the cell on the sheet.  The second is when
the
cursor/focus is up in the Formula Bar.  Since I am not the world's best
typist, and I normally go for speed more than accuracy, I often find
that I
need to back up in the cell to make a correction.  The default entry
focus
is in the cell on the sheet; when I attempt to use any of the <cursor
arrow>
keys to maneuver around in the cell, the cell loses focus and focus
changes
to an adjacent cell, and then I have to move my hand from the keyboard
to
the mouse, move it to the Formula Bar, and click.  This is a huge
time-waster for me.  Once the focus is in the Formula Bar, I can use the
<cursor arrow> keys to maneuver around the cell's contents.

I understand that the design of the <cursor arrow> keys is a huge part
of
how one maneuvers around in Excel, but I am such a keyboardist that I
would
rather be able to limit the <cursor arrow> keys to maneuver within a
cell
and have only the mouse and tab keys to change focus to different cells.

There's gotta be a way.

--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing
list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.