View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KP[_3_] KP[_3_] is offline
external usenet poster
 
Posts: 15
Default Macro handling "Insert comment"

Hi,

Can someone help me to write a macro doing the following:

When I click "Insert comment", I want the date and time to be standard in
the comment box just below the first default line with the username.

I want it to be available already when I open the file without having to run
the macro manually or by keyboard selection.

In addition, is it possible - in the same macro - to change the first line
with username from bold to plain text.

Thanks
K. Pedersen