Replies

Hello Peggy,

You said you tried the outline number dialogue box, but did you do the following:

Go to Format/Bullets and Numbering and select the Outline number tab. The dialogue box shows you 8 galleries and the bottom four use a style that is prefaced with something like Article , Heading 1, Section 1 etc.
Select Article 1 and then press the customise button in the right hand corner of the dialogue box.

Here you will see the 9 levels of outline numbering. To the side you will see in the Number format box the word Article and then the number codes that are shaded in grey, delete the word Article or whatever and insert the text of your choice.

And if you completely mess it up, there is one of my favourite buttons to fall back on – RESET!

Hope this helps

Perhaps you can explain what is happening, I use Excel and Word 2000.

If you use paste special as picture or metafile, you do not get the Excel gridlines.
If you use paste special and insert as a bitmap, you get the gridlines
If it is just a copy and paste, the Excel info is inserted as a Word Table

Thanks

Wassim

I was given the same task by the company I work for.

Previously to assess Excel skills, they would send out check sheets and questionaires for people to self assess. Based upon the answers it was determined how much additional training time was required to meet the company standard. Unfortunately, most people are not ‘honest’ with self assessment and unless you watch while they do a paper test you will get a small number who will ‘cheat’.

I created a test of 61 tasks from opening a worksheet to charts and basic functions. The test is timed (40 minutes) and I observe how people are doing. It may be time consuming but you can really tell who knows their stuff and who is struggling. Some assessment software we tried I found was too easy and people were able to figure out the answers without understanding the why and what.

By having certain tasks to perform on certain worksheets and adding conditional formatting, you can easily see where people really stand. They save the results on the network, I open up their workbook and I can review the results at my leisure. Marking it only takes about 5 minutes per person.

Good luck to you.

The only thing that I can think of is either use the Reviewing toolbar and select track changes and insert your comments by just typing them in or perhaps using the highlighter pen at least it will show up in the document.

If you insert the field “comments” from Insert/Field that will only show comments that are inserted on the Summary Tab of the document properties. File/Properties/Summary Tab/Comments and I don’t think that is what you are trying to do.

When you click on the X-ref it hyperlinks to Fig1. After I deleted Fig1 and updated the Fields so the Figures would be numbered correctly, I would have thought that when clicking on the x-ref it would hyperlink to the new Fig1. I can understand if I deleted Fig1 and didn’t update fields that it wouldn’t have anything to reference to. I assumed that if a an item is x-ref’d to Fig1 Word will look for anything that has been captioned Fig1.

But you know what happens if you assume

Attached is an Example of a formula that I use. I originally found this formula on John Walkenbach’s website. It has come in very useful.

I have passed this information on and this seems to be the solution.

Thanks to everyone for their help.

Password to modify. If the Excel workbook is copied from the CD to a pc, the password to modify disappears. It seems to perform a Save As type function.

If he ZIPs the file and then extracts it from the CD to the pc the password to modify remains. . Send out a CD with the file as a self extracting ZIP? But I think we need to understand what is going on.

What he doesn’t want to happen is someone to be able to overwrite the original Master file, so to speak. The users of the workbook will have very little Excel experience. They will just fill in the information, press a few buttons the macros etc will generate the analysis and a report.

I never knew about double clicking the autofill .

I would like to add a note here, as a help to those new to absolute referencing. Rather than trying to remember where the $ are placed in the formula, (because I always get it wrong), highlight the cells in the formula that need to be absolute and press the F4 function key at the top of the keyboard.

Thanks Dave
It works beautifully and it is exactly what was needed

Thank you for your advice, creating a signature with a graphic was easier. But it doesn’t solve my problem…if it the message was sent as HTML the logo disappeared. If it was sent as Rich Text, it was there but could then be manipulated. For me personally I would be quite happy for the company logo to be sent to Valley of the Geeks for the Banner Ad treatment, as for the rest of the firm, they would have a bad case of humour failure. Is the general consensus,” you can’t always get what you want?” or am I being dim

But thank you to everyone who has sent comments, it was very much appreciated.

Hetty

I followed your instructions and when I clicked on advanced, note pad opened, so I changed the mail format from HTML to Outlook Rich text and repeated the instructions. It worked perfectly. Thank you but…when the recipient openes the message, they are able to manipulate the inserted graphic. I have already yelled at a colleague who used his scanned signature in his messages, I grabbed it and created his Will and Testament naming me as beneficiary .

Any other suggestions?

Hetty

Use the Pack and Go Wizard and include the PowerPoint Viewer. This will enable people who do not have PowerPoint installed on their pcs to view your presentation. Viewer is free so you won’t need a license. Go to File and select Pack and go. And follow the instructions and don’t forget to select the option for Viewer.

Hetty

The only way I have used the keyboard instead of the mouse to launch hyperlinks was to view the presentation as a slide show, press the tab key to go to and select the hyperlink, once this action selected the hyperlink (which was usually assigned to a picture), I press enter. I haven’t tried this in PowePoint viewer though.

The shortcut keys, which you will find in the PowerPoint help menu are as follows:
Tab takes you to the first or next hyperlink

TAB -Go to the first or next hyperlink
SHIFT+TAB – Go to the last or previous hyperlink
ENTER while a hyperlink is selected – Perform the “mouse click” behavior of the selected hyperlink
SHIFT+ENTER while a hyperlink is selected-Perform the “mouse over” behavior of the selected hyperlink

Hope this helps

Hetty

I am sorry that my suggested method is not providing the results that many have hoped for. Our PR dept who furnishes our photos will only provide bitmaps. We regularly produce documents that are 30 – 40mb but for our purposes the pictures are not the primary focus of the document so they tend to be quite small in size 2.5 inch by 2.5 inch, but there are a number of them. But by using the method I listed earlier I am able to reduce a document from 23mb to 371kb.