![[Bytes Link logo]](../../../cgif/bytelnk2.gif)
MS office tips
by John Heenan - January 23, 2002 at 20:50:50:
WATERMARKS IN POWERPOINT SLIDES:In a previous issue of Office Tip Sheet, there is an item that describes how to place a watermark in Word. Here's how to add a watermark to PowerPoint. With PowerPoint open, select a Blank Presentation and choose a slide layout. Choose Insert | Picture | ClipArt, then double-click a picture to insert it. Close the Insert ClipArt dialog. At this point, the floating Picture toolbar should appear. If it doesn't, choose View | Toolbars | Picture to enable it. Now click the Image Control button in the Picture toolbar (second from the left) and choose Watermark. Left click on the picture, and from the menu choose Order | Send to Back. You will now be able to see the layout you chose earlier.
At this point you have added a watermark to only one slide. At the point where you have chosen a slide layout, choose View | Master | Slide Master. Follow the same procedure above, and when you create a new slide, your watermark will appear.
BORDERS FOR WORD TABLES:
You can really spruce up those tables if you apply 3D borders to them. To do this, Select this table, right-click and choose Table AutoFormat
When the Table AutoFormat dialog box opens, scroll down through the Formats list and select one of the three 3D formats. I am partial to 3D effects 3.
TURN OFF HYPERLINKS IN WORD:
Do hyperlinks get in your way while working in Word? There is a way to turn them off. Choose the Tools | AutoCorrect menu from the top of the screen. Next, when the AutoCorrect dialog box opens, click the AutoFormat As You Type tab. Now deselect the check box labeled Internet And Network Paths With Hyperlinks. Click OK to close the dialog box and save your selection. This should prevent all future typed hyperlinkable items from being hyperlinked.
MAKE THE CURRENT FOLDER THE DEFAULT FOR WORD
To save and open files in your current folder, here is a Word macro.
To enter this macro, open a blank document and press Alt-F11. When the Visual Basic editor opens, click an existing module or choose Insert | Module. Enter the code as shown below:
Sub ChangeCurrentFolder On Error GoTo NoGood Sendkeys (ActiveDocument.Path) SendKeys "~" SendKeys "{esc}" Dialogs (wdDialogFileOpen).Show NoGood: Exit Sub End Sub
Press Ctrl-S to save the new macro to Normal.dot (the default).
To add the new macro to your Word Tools menu, choose View | Toolbars | Customize. When the Customize dialog box opens, click the Commands tab. Select Macros in the Categories list. Under Commands, grab your new macro with the mouse and drag it to the Tools menu. When the Tools menu opens, drag down below the last item on the menu and release the mouse button. Click Modify Selection | Names and click in the entry box. Change the name to Current Folder (or whatever you prefer) and press Enter. Back in Customize, click Close to dismiss the dialog box and apply all your settings.
This macro doesn't permanently change Word's default folder settings.
DELETING EXCEL FORMATS
To remove formats in cells, just select the cells you no longer want formatted and choose Edit | Clear | Formats."
CALCULATING WORKDAYS IN EXCEL
This tip describes a method to calculate workdays considering holidays between 2 dates. To see how this works, open a blank worksheet and enter 12/1/2000 in cell C1. Then enter 12/31/2000 in cell C2.
Lets say that December 22 (If December 24 falls on a Sunday) and 25 are holidays at your office,
1) go to cell D1 and enter 12/22/2000 2) Next, enter 12/25/2000 into cell D2. 3) Go to cell A1 and enter networkdays(c1,c2,d1:d2)
The syntax of this function is: NETWORKDAYS (start_date,end_date,holidays)
So, the result in cell A1 is 19 days. If you have more days off during December, you could expand your list. For example, if you also have the 26th off, go to cell D3 and enter that date. Modify your formula in A1 to = networkdays(c1,c2,d1:d3)
Cell A1 will now display 18 working days for December 2000.
![[------STRIPE-----]](../../../cgif/str1.gif){kind=small}
Site Disclaimer Suggestions? E-Mail to webmaster@noccc.org