Comment Box

[saturnin02]

Hi,
(Excel 2002, Win XP)
Can I set up Excel so that when I write a comment it does not show the User
name at all in the comment box?
I tried to just clear the name in the option under Tools/Options but it then
defaults to User as defined in Windows.
Tx,
S

 

[Ron de Bruin]

Hi

See Debra's tip
http://www.contextures.com/xlcomments02.html#User

 

[saturnin02]

Tx for the tip.
It is kind of complex for me (VBA Newbie) but I guess I could do the Macros
suggested and have buttons on my tool bar....

 

[Norman Harker]

Hi Saturnin02!

If you don't like vba approaches suggested by Debra, you can just
manually change your User Name in Tools > Options > General

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[saturnin02]

Yes Norman.
You're right but I hate having to manually do it everytime I open Excel.
It'd be nice to have the macros and toolbar buttons.
I dt even kow how to copy and paste the VBA code on her site.
Actually, how DO I do it?
I mean WHERE do I paste the code--in VBA editor, under VBA Projects/This
Workbook, for example?
S

 

[Norman Harker]

Hi Saturnin02!

The subroutines here are ordinary subroutines (as opposed to event handling
routines). The ordinary subroutines go into Modules that you insert into the
workbook.

Probably best here is to use the Personal.xls workbook as it is likely that
you'll want to use the comment changing facility on different workbooks. But
you must first establish your Personal.xls.

Use Tools > Macros > Record New Macro
Select the option of recording it in Personal macro workbook
OK
Make a few entries in the currently open workbook
Stop recording by pressing the stop button on the Record Macro Toolbar.

This has established a Personal workbook that will automatically be opened
as a hidden workbook each time you open Excel.

In the VBE (Visual Basic Editor), just use the Insert menu to add more
modules to the Personal.xls project.

Once you have a macro recorded you can use the View > Toolbars > Customize >
Macro to add a new button to your toolbar. After adding that button, you can
then click it and assign to it your subroutine.

I'd suggest that if you really want to go a lot further with VBA, you should
get a good text such as John Walkenbach's Excel Power Programming with VBA.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[saturnin02]

Norman,
Thanks very much for your tips. Very nice of you.
Let me give it a whirl and see what happens.
I will also look for the book you mentioned.
I'll post again.
Best,
S