Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I used to control Cell Comments with the below code....
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.DisplayFormulaBar = True If ActiveCell.Column = 2 Then If ActiveCell.Row 2 Then If Len(ActiveCell.Value) 0 Then SendKeys "%ie~" End If End If End If End Sub This code now inserts a cell rather then show the cell's comments ( under Excel 2003 ) can any one help please? I find the new menu tools rather awkward and hidden when searching beyond the basic tools.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I copy only visble cells in office10 | Excel Worksheet Functions | |||
Creating Macro to copy information from cell into another cell using Add Comments | Excel Programming | |||
How can I control the positioning of the Comments field? | Excel Discussion (Misc queries) | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003) | Excel Programming |