Recent content by garrym01

A macro in 123 is merely a named range. In 123 classic you can type /rnt and lotus will create a table of all range names and the corresponding cell(s). Otherwise you can click on the navigator for a list of range names, or you can click on Range in the tool bar.

Try plotting a floating average of three values. You can further smooth it by increasing the number of values in the average.

In my current version, Release 5, I click on view, and then freeze titles, and select the appropriate option. You can also record this sequence if you want Lotus to write a script. In the olden days it was /wt and then b,v,h or c.

How do I set up a default header in Excel 97. Is there another way other than setting up a blank workbook?

We're considering put up postion control in World 7.3 cum 11. I'm curious how others have handled two situations: a. employees who are allocated to multiple jobs & business units. b. Employees who float among business units. I have theories on how to set them up, but I think the timekeeping...

You might have an old spreadsheet that has print ranges defined through the / menu or the (shift): menu. Check for any print settings in these menus and delete them.

Format(Style) the range as hidden and then (style) protect.

Anyone know if I can use SmartSuite Millennium v9.5 with Windows ME. I don't see it in the specs. thanx

How about just save (SAVE AS)it under a new name?

You can create and change pointer addresses using individual cells, and catenating the contents to form references in commands. if cell H5 has the letter B and cell I5 the value 7, the the following macro will place the pointer in cell B7 {GOTO} +H5&@string(I5) ~ I think you can see how you...

If you need to do something like this again, cheat and use the TOOLS MACRO RECORD feature. Lotus will write the script as you run through the menu commands. Just remember to turn off the recording when you are through TOOLS MACRO STOP RECORDING. You can then cut and paste from the macro...

Duh! Not enough coffee: Sorry set Output Media . . . . . . . . . F and add the library and member names. you may want a separate library for this stuff, so you can clean it out periodically.

In the Additional Parameters section set Output Media . . . . . . . . . P and provide the library and member name. You can also add fields in the output section to create delimiters, i.e. comma1, comma2 etc. Excel (and lotus) love delimited files.

I'M NEW TO THIS, HOW DO I FREEZE COLUMNS IN A REPORT (LIKE IN A QUERY)