Re: Command button continues to be visible!

Tech-Archive recommends: Speed Up your PC by fixing your registry

D/Pter

After your suggestion about the design mode checked it is not in design mode
and also ensured that the *** is not protected.

The below line works
Active***.alfa.caption= "bingo"

The below line does not work
Active***.alfa.Visible = False

Using Excel 97.

Why I require it to be visible is bcos it is a big command button and want
to be visible only when export operations are going on. So I used this above
code at the end of the procedure so that once the code is run they dont see
this command button.

Pls help, as I will be watching with curiosity as dont understand why it is
not working.

brgds/captgnvr




"Peter T" wrote:

That works fine for me in Excel-97. Going into design mode might make it
visible until exiting

Regards,
Peter T

"CAPTGNVR" <CAPTGNVR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A91FF82-456E-4202-A8F8-8627A3E4785B@xxxxxxxxxxxxxxxx

Dear All
The following code does not give any errors but the command button named
as
'alfa' continues to be visible in excel-97; command button from control
toolbox.

Active***.alfa.Visible = False

Pls advice.

brgds/captgnvr



.

Quantcast