Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comments (Excel 2000 )

    How do you set the defaults for the cell comments, e.g. font, size, bold, etc.? Currently, each one opens with my name and a very small font, and it gets tedious changing each one. I don't want my name and would like a much larger font as the default.

    Thanks,

    Tom

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    The default Cell Comment font is based on the windows settings for tooltips. Check out <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=42797&page=&view= &sb=&o=&vc=1>This Thread</A> for more details.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    How do you get rid of the default where your name appears in each comment window?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Tom,

    Excel is of the opinion that if you have comments to make, they should not be anonymous, and I dont know of any permanent method to get rid of the name insertion. Perhaps you could remove your name from the general Optiuons Tab.

    Or you could use the followinf code to insert the comment :<pre>
    Sub InsertComment()
    ActiveCell.AddComment InputBox("Enter Text for Comment")
    End Sub</pre>

    Using the above short circuits Excel's attempt at including your name. You could place a button on your toolbar, and attach that code to it. If you want it available to all your workbooks, you should place the macro in your personal.xls workbook.

    Andrew C

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    That makes sense. You can enter mission critical data anonymously but not a comment. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Andrew,

    I tried the general options idea to no avail.

    Regarding that other stuff, would you please lay out the step-by-step procedures? I have had no experience with "followinf code", attaching code to buttons, or placing macros in the personal.xls workbook.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    That's the way it is with Excel.

    However I suspect that if Excel did not insert the name, there might be many posts to this board asking how it could be included automatically without having to type it in each time..

    Perhaps an on/off option should be available.

    Andrew

  8. #8
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Just highlight the default name and type over it.

  9. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Comments (Excel 2000 )

    Tom, here is a beginners guide to moving macro code from the Lounge into your personal macro workbook:

    1) From the menu bar select Tools > Macro > Record New Macro
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  10. #10
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Before I get too deep into this, could I get some clarification on the following:

    Step 4. After hitting OK, the window went away leaving me with where to go for step 5. Do I go back to TOOLS/MACRO/STOP RECORDING?

    Step 7. A pop-up window tells me to unhide the personal file. Do I go to WINDOW/UNHIDE/PERSONAL/OK , which creates a sheet 1?

    Is the following code going to give me a blank comment window, as I desire, or is it going to say "Enter Text for Comment?" I want a blank comment window.

    Your help is greatly appreciated.


    P.S. Since I felt I should start over, I went into the VB editor/TOOLS/MACRO and deleted what I had done so far because I was also getting syntax errors. Hopefully, I have a clean slate again.

  11. #11
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Comments (Excel 2000 )

    > Before I get too deep into this, could I get some clarification on the following:
    >
    > I went into the VB editor/TOOLS/MACRO and deleted what I had done so far because I was also getting syntax errors. Hopefully, I have a clean slate again.

    By deleting, hopefully you mean removing everything in the code window. That was a good idea.

    > Step 4. After hitting OK, the window went away leaving me with where to go for step 5. Do I go back to TOOLS/MACRO/STOP RECORDING?

    Yes, someone had already done what I said not to do: they pressed the X in the upper-left corner of the stop recording toolbar. You should probably get it back. Here's how:

    Select Tools>Macro>Record New Macro from the menu. Remember the name (Macro1, probably) & press OK. Select View>Toolbars from the menu and make sure that the Stop Recording toolbar is checked. If not, click on it to make it visible. Press the Stop Recording button, the square, not the X. Finally, select Tools>Macro>Macros, select the macro you just recorded, and press the Delete button.

    > Step 7. A pop-up window tells me to unhide the personal file. Do I go to WINDOW/UNHIDE/PERSONAL/OK , which creates a sheet 1?

    Yes, exactly. Notice that the Title bar says
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  12. #12
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Sam,

    I tried the original code and your code and nothing happened. Here's a copy of what is in there:

    Sub InsertVisibleComment()
    ' ActiveCell.AddComment
    ' ActiveCell.Comment.Visible = True
    ' Macro recorded 08/08/2001 by Tom Halseth
    '

    '
    End Sub

    When I tell Excel to insert a comment, it still has my name on it. Do I need to go into TOOLS/MACRO/MACROS/RUN each time I want to insert a blank comment? I tried that also and nothing happened.

  13. #13
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Tom,

    The code I posted above will insert a blank comment without your name in th eactive cell, if you leave the input box blank. So also will the that code you posted if you remove the leading ' marks from the first two lines.

    Sub InsertComment()
    ActiveCell.AddComment
    ActiveCell.Comment.Visible = True
    End Sub

    Now you need to attach a toolbar button to the macro to make it easy to access when needed. To do this goto Tools, Customize and select the Commands tab on the dialog box. Scroll down the list of categories until you find macros, which you should select. You should then see an option for Custom Button (it will have a yellow smiley face beside it). Drag that button to the toolbar, and then dismiss the dialog button. If you now click on the new button on your toolbar, a dialog button should pop up asking which macro you want to assign. Assign the above macro and you should be in business.

    Andrew C

  14. #14
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Andrew,

    Hooray!. <img src=/S/joy.gif border=0 alt=joy width=23 height=23> It now works after I removed the leading ' marks. Here is the code as it looks now:

    Sub InsertVisibleComment()
    ActiveCell.AddComment
    ActiveCell.Comment.Visible = True
    ' Macro recorded 08/08/2001 by Tom Halseth
    '

    '
    End Sub

    What did you mean by "leave the input box blank?" In your previous post, you made reference to "removing everything in the code window" to remove a macro. When I aborted an earlier attempt, I only went to TOOLS/MACRO and selected the named MACRO and hit delete. I didn't go into the actual lines of code and delete them. Is there somewhere I need to do that?

  15. #15
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Comments (Excel 2000 )

    Tom,

    <hr>?" In your previous post, you made reference to "removing everything in the code window" to remove a macro<hr>

    I think you might be mixing me up with somebody else.

    In the initial code I posted, an Input Box was part of the solution so that your comment could be inserted in the comment box (can't see much point in an empty comment box), and the comment box would be visible if you have View Comments set to on, otherwise it would be hidden until you hover the mouse over the comment indicator.

    However if all is working as you want, it is probably best left alone.

    Andrew C

Page 1 of 2 12 LastLast

Posting Permissions

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