ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pictures and buttons (https://www.excelbanter.com/excel-programming/335330-pictures-buttons.html)

antonov

pictures and buttons
 
hello all....
I've created a worksheet using
http://www.mcgimpsey.com/excel/lookuppics.html as a starting point....
everything works ok but....
I need to place a commandbutton in the sheet which, when pressed, will open
an userform.
When I input the data in the cell that will then display the logo my
commandbutton disappears... just as if it is a picture... is that a way to
make it stop from doing that?



JE McGimpsey

pictures and buttons
 
What code are you using? There's nothing in the code on that site that
would hide a commandbutton from the forms toolbar or Controls Toolbox.

If your "commandbutton" *is* a picture, just unhide it before the macro
ends...

In article ,
"antonov" wrote:

hello all....
I've created a worksheet using
http://www.mcgimpsey.com/excel/lookuppics.html as a starting point....
everything works ok but....
I need to place a commandbutton in the sheet which, when pressed, will open
an userform.
When I input the data in the cell that will then display the logo my
commandbutton disappears... just as if it is a picture... is that a way to
make it stop from doing that?



All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com