Change default comment format

C

c_atiel

I do not want initials ever at the beginning of comments on an Excel 2007
spreadsheet.
This should not be the problem it seems to be.
It is an annoying waste of time to manually delete them when creating a
comment.
There does not seem to be a way to alter the default formatting for
comments, short of altering the default font, which still requires altering
Windows system fonts just as it did in Excel for Windows 3.X, which says a
lot about Microsoft programming.
Removing initials from "personalize your copy of Excel" does not work as
Excel ignores this and recreates the initials.
Stripping the author's name from the spreadsheet metadata does not work.
Worse Excel insists those initials be in Bold face.
Short of writing a macro is there a simple way to get rid of comment
initials completely and forever?
 
O

ozgrid.com

The only way I know of is replace your initials with a Space in Excel
Options username.
 
C

c_atiel

Using a space does not work, Excel replaces the initials.
I do not understand why a complex macro is required to accomplish so simple
a thing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top