|
Dan, 1) Strange -- Excel2003 uses .xls just fine, oh well, glad you found it. Yes, Normal.dot is my friend in Word too. 2) Yes, the & is concat in VB. As for the path, check out the following. I don't know if .FullName is new in 2003 or not. ActiveSheet.PageSetup.LeftHeader = ThisWorkbook.FullName 3) You need to digitally sign the macro, then trust things published with that signature. You should be able to self-sign, no need for a "real" certificate, but it's been a while since I looked into that. Or, in 2003 I have an option called "Trust all installed add-ins and templates", check into that. -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 12:59 PM To: PC Technical Discussion for iSeries Users Subject: RE: [PCTECH] Two Excel questions 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 -- 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
