View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Jason[_9_] Jason[_9_] is offline
external usenet poster
 
Posts: 7
Default Problem with command button name

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