This is all a guess:

You may be able to give a command button a name longer that 32 characters,
but my guess is that the 1st 32 are all that matters. It may be that those
32 characters have to be unique among all command buttons names (maybe among
all control/shape/object names) and any additional characters are
essentially ignored.

If the first 32 characters of a name are not unique the name will not be
accepted and will not 'stick'.



"Jason" wrote in message
om...
Gord

It seemed like a pretty low number to me, but once I reduced the names to
32 chars or less, all my problematic buttons started to work right. What
can I say? Wierd.
Any thoughts why this might be the case?

On Wed, 17 Oct 2007 15:58:53 -0700, Gord Dibben wrote:

Jason

With button from Control Toolbox or Forms Toolbar I can get way more than
32
characters to appear after save/close and re-open.


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 22:28:29 GMT, Jason
wrote:

Turns out my problem was that the descriptive names I had chosen for the
Command Buttons were too long. 32 characters seems to be the limit.

Thank you Dave for your suggestion.

On Wed, 17 Oct 2007 19:42:34 +0000, Jason wrote:

Hi,

I am having a strange problem.
I have a workbook with 20 or so sheet, and on each sheet is a command
button. I have changed the default name of most of the command buttons
to
better reflect its purpose, but a couple of them have been giving me
trouble.
I can change the name, and it stays that way while I have the workbook
open. But once I save the workbook, close it and then reopen it, the
name
that I entered has reverted back to the default "CommandButton1". Any
idea
what is going on here?

Thanks