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

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 <cava...@discussions.microsoft.com> 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

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 <cava...@discussions.microsoft.com> 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
>
>