Changing default format for comment boxes in Excel

  musicbassman 12:28 07 Jun 03
Locked

Can anyone tell me how to change the default format of comments in an Excel sheet ? The Help file says choose ‘comment’ from the drop down format list, but this choice is not given in the list.
I know how to change the format for an individual comment, but not how to change the default settings for a sheet.
Also, I know how to drag a comment box to a new position, but next time the comment box opens, its back in its original place. Any ideas? Thanks.

  musicbassman 22:56 07 Jun 03

Oh dear. Does no one know the answer to this ?

  powerless 22:58 07 Jun 03

Vog™ will.

Just hang on and he or someone else will know.

...I do not know.

  VoG™ 00:34 08 Jun 03

And the answer as far as I know is that you can't do this, at least not easily.

Apparently the font size that you see in the comment is governed by the font size that you set for desktop properties for tool tips (yes, really). However you are then stuck with Tahoma as the font.

I think that there are three things that you might want to change:

1) the font size - see above;

2) the size of the comment box; and

3) the position of the box.

You can record a macro to do (2) and (3) by operating on a single comment and then modifying that macro to do the same thing with every comment on a sheet. An (easier) alternative is to use a macro to autosize every comment - however this will not change the position of the comment.

If you wish to pursue these possibilities please post back and I'll help as far as possible.

  musicbassman 08:43 08 Jun 03

Thanks VoG, its the font size thats the main problem. Because the main sheet I'm using this on is set at 75% sizing, the comment font is tiny. I just hoped that there would be an easy way of changing the default font size, rather than having to resize every individual comment, of which there are many.
So, how do I access the desktop properties for tool tips ? Its not an option on the main desktop properties menu.

  VoG™ 08:48 08 Jun 03
  musicbassman 09:42 08 Jun 03

Thanks VoG, thats solved the font size problem. What a useful site mrexcel.com is - I have added it to my favourites. I am obliged to you.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…