A
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
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