Recent content by rschaaf

How can I use the last value from a column in excel for a formula in a specified cell? I am using excel to calculate yields of investments; today's rates are added at the bottom of column X, and weekend are left blank. In Cell Y1 the current yield must be calculated. Until now, I change the...

Well, normally the header is on top of the page, that is, on the short side of the paper in portrait. When I insert a section in landscape, the header remains on top of the page: on the long side of the page (the header doesn't rotate). I want my header to rotate with the page, to the short...

That's right! Just make sure that the global.dot is stored on a (network) drive that all users have access to, otherwise of course the link doesn't work... good luck, Robert

I agree with Gerry, but would like to add a trick: don't copy the file global.dot to all the users' startup folders. You may end up with different users having different versions of the global.dot, if they don't update it using your batch file. I also use a 'global.dot' but copy only a LINK to...

In my WORD documents I want to incorporate rather broad tables that do not fit on the page when in portrait lay-out. I guess I have 2 options: either rotate the table, but that will probably cause a neck injury, or start a new section in landscape layout for the tables. However, the problem is...

Well, Gerry and Peter, Combining your tips did the trick. I placed Gerry's AutoOpen Sub in Normal.dot and replaced "Visible" by "Enabled". This appears to be vital. Thank you very much!

Thank you for your tip, it is quite useful. However, it works only for the document that contains this code, and since I am working with thousands of documents, I'd rather permanently disable (or even delete) these toolbars.

Maybe I wasn't clear enough... Of course, disabling these toolbars is what I do all the time. But I am working with many documents every day and disabling the toolbars after opening every new document is annoying. I know I could empty the toolbars and place them permanently behind the...

I am using MS Word 2002 for a few months now, and am annoyed by the toolbars "Web" and "Reviewing" that keep popping up whenever I open a document or follow a hyperlink. Does anyone know a way to stop this?

'Zathras': I don't want the Ó, ó, or à (produced by ALT+ 224, 0243 and 0224), but I need the Greek letter alpha (a in the font 'Symbol'). However, I need to use the keyboard to type it because I'm entering it into a textbox, together with 'normal font' letters. John: This what I was thinking...

I think you really need to make a template. Indeed, previous documents will not be changed when the template is changed, I'm afraid you'll have to copy and paste the contents into the new template. More reason to really think carefully about the lay out of your template I guess. You can use an...

I am fully aware of that, unfortunately I really need the alpha and it is not included in the extended set. Let me explain the situation: I am writing a WinWord template for documents concernig chemical products. In an opening screen, the products' name is entered into a textbox. This name is...

thanks, this clarifies my problem, but unfortunately doesn't solve it. It seems I have to work around it...

I am looking for the right settings to be able to use the proper ASCII codes. I suppose it is related to keyboard- or regional settings, but I cannot seem to find the answer...

After document authorization, it is finalized by a macro and should be processed in a database. To prevent forgetting this, I want to include it in the macro. It is not necessary to return to Word after editing the database.