+ Reply to Thread
Results 1 to 8 of 8

Change all Comments position to 4 rows down

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Change all Comments position to 4 rows down

    Hi people,
    Following code makes some adjustments for all comments in the workbook.
    Following code is okey.
    Please Login or Register  to view this content.
    My question is;
    How can I show all comments 4 rows down? Or 2 cm down ?
    P.S.: There are a lot of comments in the workbook and all of them exists in the different cells.

    Check enclosed file.
    Attached Files Attached Files
    Last edited by HerryMarkowitz; 08-15-2014 at 01:26 PM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Change all Comments position to 4 rows down

    Hi Herry,
    something like
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Change all Comments position to 4 rows down

    Hi nilem,
    Add an extra comment into file which I atttached.
    Try your code again.
    You will see that your code doesnt work for second comment... Any other opinion please ?

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Change all Comments position to 4 rows down

    try attached
    Attached Files Attached Files

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Change all Comments position to 4 rows down

    Hi nilem,
    What is problem enclosed file?
    Attached Files Attached Files

  6. #6
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Change all Comments position to 4 rows down

    Hi nilem,
    Any step regarding this issue ?

  7. #7
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Change all Comments position to 4 rows down

    Hi Herry,
    I'm sorry, but I'm afraid that's not possible in the "Show only indicators of comments" mode

  8. #8
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Change all Comments position to 4 rows down

    I see...
    Thanks a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to change the position within a cell
    By sekharks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2014, 06:56 AM
  2. [SOLVED] Calculating position change
    By Crackerdaq in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 06:22 AM
  3. how to change position of data.
    By kghisla in forum Excel General
    Replies: 9
    Last Post: 09-14-2010, 08:42 AM
  4. Word Comments Position
    By Jade Nortan in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2010, 05:47 PM
  5. Comments box position
    By GaryR in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-21-2006, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1