View Single Post
  #30   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Code to add comments to selected cells within a selected range

Hi Howard,

Am Thu, 30 Jan 2014 17:58:23 -0800 (PST) schrieb L. Howard:

I will give that a go.


please look again in SkyDrive.
The problem now is solved with merged cells. With "Delete" the cell will
be unmerged.
After merging the selection the problem is, that you have only 1 cell so
you can't choose more cells in the selection for adding comments :-(

I also merged Y1 with Z1 and AA1 that the cell is wide enough to show
the data validation entries without changing the column width and
display flickering. I deleted the Worksheet_SelectionChange event macro.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2