View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Renaming Text Boxes and Buttons

What's the situation when you can't rename them?

Is the worksheet protected?
Do you have worksheets grouped?
Are you sure you hit enter after you typed the name in the namebox?



Don Wiss wrote:

Normally I can rename text boxes and buttons by changing the name in the
Name Box. But sometimes I can't. In this instance I'd like them to have the
same names as they have on another sheet. This so my clearing macro can be
the same for both sheets, just have the correct sheet selected. Sometimes I
can make the names the same. Sometimes I can't. Is there another way to
rename them?

Don <donwiss at panix.com.


--

Dave Peterson