Override cell comment functionality Dims <dims12[ at ]hotmail.com> 12/6/2008 2:36:19 AM Hi! Is it possible to write Excel Add-In to override cell comments functionality? For example, to allow rich text editing there. Thanks.

Re: Override cell comment functionality "Steve Dalton" <NOsteveSPAM(at)NOeigensysSPAM(dot)com> 12/7/2008 2:53:36 PM Hi Dims You can read and overwrite the comment programatically, yes, so all you would need to do is invoke some other interface through which the user edits the comment. However, you have to work within he constraints of the comment display capability of Excel, of course. If you were to do that I would recommend a command macro (or equivalent in an XLL, COM or .NET add-in) that was an alternative to the context menu default comment editor. You can either replace the default editor menu-item or add your own in addition using Excel menu customisation. Regards Steve Dalton "Dims" <dims12[ at ]hotmail.com> wrote in message news:6e2e21ea-6c52-4629-b5f8-697c3aa74c4f[ at ]13g2000yql.googlegroups.com... [Quoted Text] > Hi! > > Is it possible to write Excel Add-In to override cell comments > functionality? For example, to allow rich text editing there. > > Thanks.

Re: Override cell comment functionality Dims <dims12[ at ]hotmail.com> 12/8/2008 6:42:55 PM On 7 ÄÅË, 17:53, "Steve Dalton" <NOsteveSPAM(at)NOeigensysSPAM(dot) com> wrote: [Quoted Text] > You can read and overwrite the comment programatically, yes, so all you > would need to do is invoke some other interface through which the user edits > the comment. š Thank you and can you give me some clues, how to do that? As for now I see the following approach: to store HTML or RTF in comments and call my GUI when user calls operations on comments. But how one can intecept user calls to comments interface? > You can > either replace the default editor menu-item or add your own in addition > using Excel menu customisation. There are not only the menus to intercept. For example, when user moves mouse pointer over commented field, the popup appears. How to intercept this function? Thanks