Replies

Edited by DougKlippert on 01/04/17 02:13.

To roll your own field codes, use Ctrl+F9 to put the brackets {} on the page. Then enter the code from the KB article between the brackets. The other way is to use Insert>Field. Alt+F9 will toggle the field code off and on so you can see them.
(geofrichardson’s right I corrected my message to avoid confusion. Thanks)

The underlying principal of show biz is lie, cheat, and steal.
Use a number of slides to create the motion and the play them back with no transition and 0 time between slides.
Here’s a quick one. You’ll, of course spend more time and care.

You can make it a hyperlink. Select the button and the click on Insert Hyperlink icon on the Standard toolbar.

Right, you’re given the choice to expand your selection or to go with the current selection. I’ve seen too many people choose the later option by error. Hence the warning.

Be sure to select just one cell in the database. If you select the column, for instance, the records will be sorted out of synch

Here’s another article. Not that much has changed, but this one uses VBA:
How to make a Gannt chart

This is an old problem. You can go to Print Preview 2 or 3 times. or Print your pages in reverse. Another way is to look at Word count. Anything to force repagination.

If you want to find out to what degree a font can be embedded, try:
Microsoft’s font property add-in

For Outlook, the countries are identified between [ ]’s.
Other sites are:
and Why even go to work?, also
Chip Pearson has some VBA stuff here.

For a list of holidays, take a look at Outlook.Txt or .HOL.
It’s the file that Outlook uses to populate its calendar.
You’ll have to do some editing, but it’s a start.

I found it :
(Nothing is too obscure)
Q171661 and Q199972
A false macro warning can occur with Excel 97 when:

The workbook contains a defined name that uses syntax to refer to nonadjacent cell ranges; however the defined name actually refers to adjacent cell ranges.
-and-
The last three rows in the defined name are rows greater than or equal to row 600 and increase in value from left to right.
For example, if you create a worksheet named “Plan,” a defined name that refers to the following ranges causes the problem:
=Plan!$A$1:$A$1,Plan!$A$1:$A$1,Plan!$A$1:$A$1,Plan!$A$1:$A$1,
Plan!$A$1:$A$1,Plan!$A$1:$A$1,Plan!$A$1:$A$1,Plan!$A$1:$A$600,
Plan!$A$601:$A$602
NOTE: Other similarly defined names may also cause this behavior.
-or-
The ThisWorkbook module is missing from the workbook in the Project Explorer window in Microsoft Visual Basic Editor.
This problem was corrected in Microsoft Excel 97 SR-1.
-or-
This problem may occur when the following conditions are true:
A defined name has been inserted into the workbook.
-and-
The defined name refers to a constant of 1.5.

It was the macro warning. It related to a workbook that was created in Excel 95. When I opened it in (97/2000 ?) I got a warning. I sent it to MS and got a reply that the range names were causing the problem.
(I hate to mention it, but I did post it in the old forum )
I can’t find the correspondence. I have a test file from that period, but now I can’t duplicate the problem.
I think I’ll drop this until I can find some more info.

Of course I can’t find the documentation now! .
I found that old spreadsheets with named ranges (I think protection might have been involved as well) would often give false warnings. I even got a confirmation from MS.
I don’t remember if it was 95 to 97 or 2000.
Believe me it happened!!

Besides Modules that might still be attached, this message may appear if you have named ranges as well

If you’re copying and pasting, make sure that none of the data is in text format. One way to force the data into numeric format is to copy the number 1 from some cell – select all of the data cells and Paste Special>Multiply.