Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Reset Comments"
Hi There,
I have spreadsheets with comments on it ... which are "shown" / visible. But by playing with the spreadsheet somehow: inserting rows/ columns, scrolling, freeze panes ,...Actually I cannot recreate the issue right now! The comments appears a couple pages further (read a LOTTTTt of rows ...columns further) than next to cell where they had been inserted. IS it possible to "reset" the comments ...so that they stand nicely next to their cell again? Brgds Sige |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Reset Comments"
There's sample code here that will reset comments to their original
position: http://www.contextures.com/xlcomments03.html#Reset Sige wrote: Hi There, I have spreadsheets with comments on it ... which are "shown" / visible. But by playing with the spreadsheet somehow: inserting rows/ columns, scrolling, freeze panes ,...Actually I cannot recreate the issue right now! The comments appears a couple pages further (read a LOTTTTt of rows ..columns further) than next to cell where they had been inserted. IS it possible to "reset" the comments ...so that they stand nicely next to their cell again? Brgds Sige -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Reset Comments"
That's it !
Thanks a lot Debra Brgds Sige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I reset the default pie chart label "Other" to "Equity"? | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how do i reset the default from "general" to "number" | Excel Discussion (Misc queries) | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) |