| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format a Comment created by a Macro
Thanks to Ken Johnson's help I have a Comment box which appears only if a
condition is met. This comment has been created by a small macro. It seems that because the comment box is not a standard Excel comment, but has been created by the macro, any attempt to format the text box (dimensions, alignment, no shadow etc) fails. It looks like the formatting has to be included in the macro, but so far I haven't been able to do this. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button not bring up Macro I created | Excel Discussion (Misc queries) | |||
| Runtime error for macro that works in workbook created in | Excel Discussion (Misc queries) | |||
| ability to embed a macro within a csv | Excel Discussion (Misc queries) | |||
| How do I set up the default format for a comment? | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
