Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't think you can change the default position of the comment.

But you could use a macro to reposition them each time the workbook opens.

Debra Dalgleish has some code that may help you get started at:
http://contextures.com/xlcomments03.html#Reset

You could modify Debra's code to go through each worksheet and name it Auto_open
so that it runs when the workbook opens.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Hans Feitz wrote:

If a cell with a comment assigned to it is towards the edge of the (RH) side
of the window, the comment box will only be partially visible. Can the
default position of these boxes be changed to f.i. LH side of the cell? I
know that during editing the text box position can be changed but that is not
reflected permanently afterwards.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the Font Default for Comment in Excel 2000? Karla Excel Discussion (Misc queries) 3 September 20th 05 11:20 PM
change the defualt settings for comment boxes Rick Excel Discussion (Misc queries) 1 August 23rd 05 08:48 PM
How do I change the "comment" default location ? RRR Excel Worksheet Functions 1 August 3rd 05 04:35 PM
How do I change the Defaults for the Excell comment box. JEN Excel Discussion (Misc queries) 2 June 2nd 05 08:43 PM
Change the default chart colours TonyJD Charts and Charting in Excel 2 January 20th 05 01:06 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"