Replies

Ah Ha… The results are based on rather large formula and which are shown with fixed decimal.

Santa’s first name is Hans

Thank you

Hans
That seems to sort out some of the problems. In one workbook we’ve got the formula on our summary sheet =If(T24=Master!T647,True,False) T24 does equal cell T647 on the Master Worksheet but we keep getting “False”, yet a similar formula but based on different cell references) in the row above gives the correct response. Is there something wrong in our formula? We may have been looking at it too long.

I use Windows 2000 and this is how I solved the problem for me.
Go to Start/Settings/Control Panel and then to Regional Options
Go to the numbers tab and under measurement change the setting from Metric to US.

Hope this helps.

Is that before or after the deep fried pizza washed down with an Irn Bru!

Sorry for the delay, but I got the message. I had a few days off work. Hurrah!. And I have amended my profile.

I have seen messages and greetings like the one’s shown in the links done in Hallmark Greetings. But I don’t know how much control you have over the preset projects. Quite fun for Christmas.

Regards

Thank you very much from me and thank you from my colleague. I have passed the message on.

The only telepropter effect that I have used is drawing text box, filling it with text and then placing it above the slide. Then added the custom animation effect of Crawl from Bottom. Can be effective, but I am not sure how you can control the speed of the crawl. Fine for rousing gospel singing and very fast readers but a bit hard on the poor old dears with Amazing Grace

I would be interested to see the original message

Howard
We are only using Office 2000, but straying from the thread, I looked at your site and was very interested to read what you said about WordBasic. We have 48 sets of templates (each with 28+ templates with macros)for our offices. They were all written in WordBasic and it caused no end of trouble when we upgraded. At least I will have some information to back me up when I tell them during the next upgrade, that we are going to have to make the change to VB.

Regards

I have known about Excel Page for some time and have found it very useful. The first thing I do when I get to work in the morning is get a cup of tea, go straight to WOPR, J-Walk to read the Blog and to Arizona Central to look at the comics… A simple trio of sites that help me make it through the day!

Regards and thanks

Dear Hans and Wendell

Thanks very much.

I see that the Support Site you gave says United States. I usually look under the section for the UK. Apart from language, text and currency specs, does this mean that the bulk of information available is drastically different between locations? And if so, which is the best for me to look at?

Hello

Unfortunately, I do not have an answer to your problem, but I have found that the Organisational Chart used in Word and PowerPoint, is one of the most useless features I have ever come across in Office.

Have you thought about using the drawing toolbar to make an organisational chart? You have a lot more scope for creativity and for charts other than the rigid corporate structure provided by the Org Chart. This is what I do:

Create a text box based on the person with the largest name and title, this way you will have identically sized boxes,
Format the text box and fill the background as white, (or what ever colour you want)then copy the box to the correct position on the chart. (Hold the Ctrl key down and click drag and drop to quick copy)
Connect the boxes together with line draw and format the order of the line as Send to back, so it doesn’t matter if you are over into the box as the white or colour fill covers the line anyway.
Change the names and titles as necessary.
Group all the object together.

You can do all this a h*** of a lot faster than messing with the organisational chart.

Good luck

If I am understanding your message correctly, you have a worksheet open but it has the Outlook e-mail toolbar showing and saying Send this sheet, To: CC:

Check to see if you have on your toolbar an icon that looks a mail envelope. If you hover above it it will say e-mail. Most likely it is highlighted or looks pressed in. Just click on it again and it will remove the e-mail header.

Hope this sorts out the problem

I copied the code over and ran a test and it worked . The only oddity we had to deal with was hard returns or line breaks in the footnote section but we zapped those with a find and replace. But this solved our problem (rather his problem, it wasn’t my document!!!!)

Thank you very very much.

Hello Maureen
This is what I did to try to create the effect that you were looking for.

I created a text box with sample text
Then I copied it four times so I had a list of the same text
Then went to Custom Animation and applied the following
Text 1/Order and Timing Start Animation automatically 00:01
Text2/Order and Timing Start Animation automatically 00:01
Text3/Order and Timing Start Animation automatically 00:01
Text4/Order and Timing Start Animation automatically 00:01

On the Effects tab, under Entry I selected Appear and Hide after animation

Then I tested it in Slide show to test the timings between

Dear Klaus

Then I have been very lucky and being a firm believer if anything can go wrong it will, I shall try it differently next time.

Thanks for the warning