Powershell and Excel Comments: Formating Question about Excel Comments
Posted on 2010-09-16
I've got two questions I need answered:
1) Is it possible to setup Excel some that comments inserted into a cell can be viewed using slider bars (bottom and right side sliders)?
2) How do you turn this on in either Office (2007 / 2010) or via PowerShell Code?
I've got an audit in Powershell that dumps installed applications into the comment field of a computer name.
But sometimes there is to much information to see in the comment field, and without sliders you have to EDIT the comment to VIEW the information.
Can anyone help me with this?
The powershell code looks likething like this:
#Add the comment to the call
# Set the size of the comment area to a readable size
$CurrentSheet.Cells.Item($EventRow+1,$EventCol+3).Comment.Shape.Width = 50 * 15
$CurrentSheet.Cells.Item($EventRow+1,$EventCol+3).Comment.Shape.Hieght = 30 * 15