View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chief Garcia Chief Garcia is offline
external usenet poster
 
Posts: 1
Default Auto Insert Comment box in Excel

Hi, I was wondering if there is a way to make excel Insert a Comment box
automatically?
For example:
I have a data sheet that has names and number and I run into the issue that
I need to right click on the Insert another culumn, then after I have
inserted the extra column. Now I have to go an insert a comment box on each
of the cells.

But I don't want to copy and insert either. Is there a way to make excel
have the comment box already there when I insert a new column?

If so how can I do this or is there a macro that I can use to make this
happen?