XL4 Macros Error - Font Size Must Be Between 1 and 409

[Art]

I have an old XL4 macros program with a series of custom menu commands.
As there is no single macro for the Excel Format/Cells... command, I
attempted to implement five different commands as using the following:

Font: FONT.PROPERTIES?()
Number: FORMAT.NUMBER?()
Alignment: ALIGNMENT?()
Borders: BORDER?()
Patterns: PATTERNS?()
Cell protection: CELL.PROTECTION?()

When executing these commands in the dialog prompt form, all will fail
with the dreaded "Font Size Must Be Between 1 and 409" alert except for
FONT.PROPERTIES?() when executed under Office X (10.1.9). The
non-dialog versions work as advertised.

All of the dialog versions run OK on Excel under Office/2k.

This would appear to be related to the syndrome described in
http://support.microsoft.com/kb/312260. However, the workaround has no
effect in this case.

Other than writing custom dialogs for each command, is there a magic
trick to get around this ?

TIA.

Art

 

[Bob Greenblatt]

I have an old XL4 macros program with a series of custom menu commands.
As there is no single macro for the Excel Format/Cells... command, I
attempted to implement five different commands as using the following:

Font: FONT.PROPERTIES?()
Number: FORMAT.NUMBER?()
Alignment: ALIGNMENT?()
Borders: BORDER?()
Patterns: PATTERNS?()
Cell protection: CELL.PROTECTION?()

When executing these commands in the dialog prompt form, all will fail
with the dreaded "Font Size Must Be Between 1 and 409" alert except for
FONT.PROPERTIES?() when executed under Office X (10.1.9). The
non-dialog versions work as advertised.

All of the dialog versions run OK on Excel under Office/2k.

This would appear to be related to the syndrome described in
http://support.microsoft.com/kb/312260. However, the workaround has no
effect in this case.

Other than writing custom dialogs for each command, is there a magic
trick to get around this ?

TIA.

Art

I can't think of one. Looks like a bug. I'll report it. You should do the
same via send feedback on the help menu.

 

[Art]

I can't think of one. Looks like a bug. I'll report it. You should do the
same via send feedback on the help menu.

Bob,
Thanks for the conformation. I'll send the feedback on the bugs per your
suggestion.

However, it is my understanding that the only fixes being entertained
for Office/X are security-related. In fact, the Mactopia site doesn't
even show the existing updates for Office X. Is this correct ?

Art

 

[Bob Greenblatt]

Bob,
Thanks for the conformation. I'll send the feedback on the bugs per your
suggestion.

However, it is my understanding that the only fixes being entertained
for Office/X are security-related. In fact, the Mactopia site doesn't
even show the existing updates for Office X. Is this correct ?

Art

Yes that is correct. Office X is "end of life" and no longer supported. It
will not please you to learn that this same bug exists in Excel 2004 and
2008.

 

[Art]

On 2/11/08 3:22 PM, Bob Greenblatt wrote:

[...]

Yes that is correct. Office X is "end of life" and no longer supported. It
will not please you to learn that this same bug exists in Excel 2004 and
2008.

Ah, forward compatibility taken to the extreme .

Although this is a show-stopper for the specific macro commands, I did
come up with an alternative solution:

By allowing the worksheet to become unprotected for the duration of the
formatting, the full formatting dialog box (equivalent to the standard
Format / Cells... command) can be invoked, but only via the keyboard
CMD+1 (one). There doesn't seem to be a way with XL4 macros to migrate a
menu command from a standard menu to a custom menu except via a defined
macro command.

Also, the Formatting Palette becomes usable as well.

This is less than desirable as there is the potential for inadvertent
formula corruption with the sheet protection off, so it's a trade-off.

Art