Excel macro recording for formatting a comment in a cell not possible

Question

I'm trying to record a macro in Excel while formatting a comment for a cell. But only the text content will be recorded.

Changing of background color, pattern e.g. are not recorded.

The button for stop recording is dimmed when I enter the dialogue box for formatting.

Recording a macro for formatting a cell e. g. has no problems.

Excuse me for bad English, I'm a german user.

Answer 1

Hi,

I suggest you check if you have enable the Use Relative References option:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you for answer. I have activated the option but only formatting of the text (e. g. font, style, size) will be recorded. Other features like pattern, background color are still not recorded.

The button for break recording is now not dimmed.