RE: Two Excel questions -- PCTECH

Thanks Walden & Vern!

Only one slight correction in Walden's post: "save this as Book.xlt", not
.xls.  You can imagine the frustration I was having with that one!

Have customized normal.dot in Word for years, never thought to do it in
Excel!  Now I have all my normal Excel customs (The file's Title in center
header, &Tab in right header, &File in left footer, Page n of nn in center
footer, and save timestamp in right footer) in the default template!  Wow,
what a day!

OK, now *really* make my day (not Clint Eastwood style, of course! <g>) and
show me how to prepend the text "Last Updated: " to the save timestamp that
gets printed in the footer.  I tried to enter that in the normal "Customize
Footer" dialog box, but it got replaced by the function when the spreadsheet
was saved.  I imagine it needs to be done in the function, but can't really
see how I'd do it.  Oh, wait, I dug & dug through the help and figured it
out.  '&' is the concatenator, eh?

Now, how about being able to print the path along with the filename?
(Currently, I can only print the filename w/o the path in the left footer.)
Is that a VBA macro as well?  It doesn't appear to be one of the
BuiltinDocumentProperties.  I've been all over the VBA help on this as well,
but nothing stands out.

Also, is there a way to keep this macro from triggering the dialog box that
makes you choose between disabling and enabling macros?  I would like to
keep that behavior *except* I'd like this particular one to be marked
"trusted" somehow so that it doesn't trigger the warning.

I guess that's more than two Excel questions!

Many, many, many thanks!

- Dan

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]On
> Behalf Of Walden H. Leverich
> Sent: Friday, August 27, 2004 10:12 AM
> To: PC Technical Discussion for iSeries Users
> Subject: RE: [PCTECH] Two Excel questions
>
>
> 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.
>
> --
> 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