View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default looking for a losing button

Hi Dan,

By your method, I coud not find it, but I am sure it is still there since I
can run the follwoing statement in Immediate Window:

sheets("English Inspection").btnEqp.visible = true

btnEqp is the name of the missing button and English Inspection is the
sheet name.

Thank you very much for your help!

Clara


"dan dungan" wrote:

Hi Clara,

When that happens to me in Excel 2000, I view the control toolbox
toolbar and select design mode. Then the control becomes visible.

Dan

On Oct 9, 11:25 am, clara wrote:
Hi all,

There used to a button on one of my sheets,but all of sudden it disappers(I
did not delete it), I am guessing it is hiding somewhere else, could you tell
me how to find it on my worksheet, I tried to use the name box on the
formula bar, but it doesn't work.

Clara

thank you so much for your help