Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cmdbarmenu focus problem
Dear all,
I have a complex form using Excel, the processes on the form all work well. I have removedmenu bar items that are not required and added ones of my own to manage how users use the form. This enables actions that are required and disables actions that are not. My problem is that when a user activates acell or range on the form and then goes to use one of the menu bar items it does not work. They have to release the cell first. Is there a way of taking focus from the cell and ensuring that the menu bar item gets it and the on action then works? Here is the code I use to set the items (this is one of about 5) Set CmdBarMenu = CmdBar.Controls.Add(Type:=msoControlPopup, befo=hindex) CmdBarMenu.Caption = "&Refresh Form" CmdBarMenu.OnAction = "'" & ThisWorkbook.Name & "'!thisworkbook.refreshform" Manmy thanks for any help or advice in advance. Paul -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cmdbarmenu focus problem
With the cursor active inside the cell it is impossible to get a menu item to work. That is just the way Excel is. You will have to make sure your users understand that. An alternative is to uncheck the "Move Selection After Enter" setting on the Edit tab in Tools | Options. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "pjbur2005 via OfficeKB.com" <u18722@uwe wrote in message Dear all, I have a complex form using Excel, the processes on the form all work well. I have removedmenu bar items that are not required and added ones of my own to manage how users use the form. This enables actions that are required and disables actions that are not. My problem is that when a user activates acell or range on the form and then goes to use one of the menu bar items it does not work. They have to release the cell first. Is there a way of taking focus from the cell and ensuring that the menu bar item gets it and the on action then works? Here is the code I use to set the items (this is one of about 5) Set CmdBarMenu = CmdBar.Controls.Add(Type:=msoControlPopup, befo=hindex) CmdBarMenu.Caption = "&Refresh Form" CmdBarMenu.OnAction = "'" & ThisWorkbook.Name & "'!thisworkbook.refreshform" Manmy thanks for any help or advice in advance. Paul -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cmdbarmenu focus problem
Jim Thanks for you reply,
Appreciate your point but why then is not the same for "file", "View" or any other menu bar item appart from those I have added? Unchecking the "move Seelction........" made no differance. I have around 400 to 600 users, some understand, some think they do and the rest cant be bothered too! Paul Jim Cone wrote: With the cursor active inside the cell it is impossible to get a menu item to work. That is just the way Excel is. You will have to make sure your users understand that. An alternative is to uncheck the "Move Selection After Enter" setting on the Edit tab in Tools | Options. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using newly created user function in Excel 2003 | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |