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
|