![]() |
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 |
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 |
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