| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button continues to be visible!
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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command button continues to be visible!
That works fine for me in Excel-97. Going into design mode might make it
visible until exiting Regards, Peter T "CAPTGNVR" wrote in message ... 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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command button continues to be visible!
D/Pter
After your suggestion about the design mode checked it is not in design mode and also ensured that the sheet is not protected. The below line works Activesheet.alfa.caption= "bingo" The below line does not work Activesheet.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" wrote in message ... 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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command button continues to be visible!
In a new sheet add a button named CommandButton1 and run the following from
an ordinary module, obviously with the sheet active. With ActiveSheet.CommandButton1 .Visible = Not .Visible End With For me this toggles visibility of the button in Excel-97, as expected. Regards, Peter PS, what does D/Pter mean "CAPTGNVR" wrote in message ... D/Pter After your suggestion about the design mode checked it is not in design mode and also ensured that the sheet is not protected. The below line works Activesheet.alfa.caption= "bingo" The below line does not work Activesheet.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" wrote in message ... 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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command button continues to be visible!
D/Peter
Yes this code worked in the new sheet. But I tried the same by placing a new command button and tried and the command button continues to be seen. Thnks for the folow up. Pls adv. brgds/captgnvr "Peter T" wrote: In a new sheet add a button named CommandButton1 and run the following from an ordinary module, obviously with the sheet active. With ActiveSheet.CommandButton1 .Visible = Not .Visible End With For me this toggles visibility of the button in Excel-97, as expected. Regards, Peter PS, what does D/Pter mean "CAPTGNVR" wrote in message ... D/Pter After your suggestion about the design mode checked it is not in design mode and also ensured that the sheet is not protected. The below line works Activesheet.alfa.caption= "bingo" The below line does not work Activesheet.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" wrote in message ... 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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Command button continues to be visible!
Post the your code, I mean the actual code.
Regards, Peter T "CAPTGNVR" wrote in message ... D/Peter Yes this code worked in the new sheet. But I tried the same by placing a new command button and tried and the command button continues to be seen. Thnks for the folow up. Pls adv. brgds/captgnvr "Peter T" wrote: In a new sheet add a button named CommandButton1 and run the following from an ordinary module, obviously with the sheet active. With ActiveSheet.CommandButton1 .Visible = Not .Visible End With For me this toggles visibility of the button in Excel-97, as expected. Regards, Peter PS, what does D/Pter mean "CAPTGNVR" wrote in message ... D/Pter After your suggestion about the design mode checked it is not in design mode and also ensured that the sheet is not protected. The below line works Activesheet.alfa.caption= "bingo" The below line does not work Activesheet.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" wrote in message ... 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. Activesheet.alfa.Visible = False Pls advice. brgds/captgnvr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deselect Command Button by Selecting another Command Button | Excel Programming | |||
| Autofilter: jump from visible row to visible row by command button | Excel Programming | |||
| Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
| How do I make a command button invisible or visible? | Excel Programming | |||
| Make Command Button visible only in .xlt? | Excel Programming | |||
![CAPTGNVR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
