View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Problem with command button name

And you're positive that you've saved the workbook?

And you're positive that you're opening the workbook that you saved?

One test if you're positive...
Open the workbook
make the changes
save the workbook
close excel

Open excel in safe mode
windows start button|run
excel /safe
file|open your workbook that was just saved

Are the commandbuttons renamed?

If no, then maybe you have a macro that's changing the names of your
commandbuttons each time you open that workbook???

If yes, I don't have a guess.

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


--

Dave Peterson