ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command Button disappears (https://www.excelbanter.com/excel-programming/402026-command-button-disappears.html)

cavasta

Command Button disappears
 
I've inserted a command button called 'menu' into my spreadsheet. When it's
activated a userform appears. I've added an accelerator to the 'menu' command
button ('n'). When I manually click on the button, everything's ok - the
userform appears. But when I press alt+n, the userform still appears but the
'menu' command button disappears. Even when the 'menu' button's invisible, I
can still activate the user form either by clicking on the button or by
pressing alt+n. I can make the menu command button reappear by clicking on
any cell in the spreadsheet.
Does anyone know what's going on?
Thanks
cavasta

WHA

Command Button disappears
 
I tried but could not duplicate this error. How could you click the
button when it was invisible?

On Nov 30, 2:25 pm, cavasta wrote:
I've inserted a command button called 'menu' into my spreadsheet. When it's
activated a userform appears. I've added an accelerator to the 'menu' command
button ('n'). When I manually click on the button, everything's ok - the
userform appears. But when I press alt+n, the userform still appears but the
'menu' command button disappears. Even when the 'menu' button's invisible, I
can still activate the user form either by clicking on the button or by
pressing alt+n. I can make the menu command button reappear by clicking on
any cell in the spreadsheet.
Does anyone know what's going on?
Thanks
cavasta



cavasta

Command Button disappears
 
The button becomes invisible. It's as if it has become transparent, which
makes it look as if it has disappeared though it is in fact still there. Very
strange.

"WHA" wrote:

I tried but could not duplicate this error. How could you click the
button when it was invisible?

On Nov 30, 2:25 pm, cavasta wrote:
I've inserted a command button called 'menu' into my spreadsheet. When it's
activated a userform appears. I've added an accelerator to the 'menu' command
button ('n'). When I manually click on the button, everything's ok - the
userform appears. But when I press alt+n, the userform still appears but the
'menu' command button disappears. Even when the 'menu' button's invisible, I
can still activate the user form either by clicking on the button or by
pressing alt+n. I can make the menu command button reappear by clicking on
any cell in the spreadsheet.
Does anyone know what's going on?
Thanks
cavasta





All times are GMT +1. The time now is 03:01 PM.

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