ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Notes move around the sheet (https://www.excelbanter.com/excel-discussion-misc-queries/11119-notes-move-around-sheet.html)

Mervyn Thomas

Notes move around the sheet
 
If I attach a note to a cell in a custom view and then change to a different
custom view where many of the columns are hidden the note moves across to a
different place! Any ideas on how to keep the note static?



Dave Peterson

I don't have a way to keep them from moving, but Debra Dalgleish has a way to
move them back:

http://www.contextures.com/xlcomments03.html#Reset

Mervyn Thomas wrote:

If I attach a note to a cell in a custom view and then change to a different
custom view where many of the columns are hidden the note moves across to a
different place! Any ideas on how to keep the note static?


--

Dave Peterson

Gord Dibben

Mervyn

By "notes" I assume you mean "Comments".

Read this google search result on this subject.

http://snipurl.com/chvb


Gord Dibben Excel MVP

On Wed, 02 Feb 2005 11:28:24 GMT, "Mervyn Thomas"
wrote:

If I attach a note to a cell in a custom view and then change to a different
custom view where many of the columns are hidden the note moves across to a
different place! Any ideas on how to keep the note static?




All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com