How to get User Form Controltiptext to appear without selecting the user form?

I have a userform permanently at the top of my workbook. This functions as my custom menu, and covers all the Excel ribbon and menus.

The problem is that Excel does not "select" this user form and the worksheet organically. Either the userform is "selected" by clicking a blank space in the userform, or the worksheet is selected by clicking a cell in the worksheet. The "selection" does not occur oganically simply by mousing over the userform and worksheet areas.

The problem is that the controltiptext of my userform buttons do not appear, unless the userform is selected. So I have to move the mouse over the userform, click a blank space and then the controltiptext appears.

Similarly the Notes on the worksheet do not appear if the userform is selected, I have to click on an empty cell and then the worksheet is selected and the notes appear.

Can I use the MouseMove event on the userform to select the userform and activate the worksheet organically? Thanks!

Because customizing the ribbon exposes the fact that the app is an Excel file, whereas I want to completely transform it into a standalone app. For the most part I've achieved it except for things like the focus issue.

Originally Posted by Andy Pope

There is no easy way to tell a user has finished with the userform and needs to see info from the worksheet or vice versa.

Hi Andy, I don't understand "there is no easy way". Isn't the easy way to use the MouseMove event of the userform? I created a label that shows the coordinates of the mouse that is triggered by the Userform_MouseMove event, to see if it is working when the worksheet has the focus, and the label is showing the mouse coordinates when the mouse is over the userform. So I would think there is a way to get the controltiptext to appear when you mousemove over the userform? But what action should I trigger? the only thing I do to get the controltiptext to appear is to click on the userform - is there a "click userform" command, or setfocus on userform?

Then to set focus back to the worksheet, I guess I could create a label that spans the bottom of the userform, and when the mouse crosses the label, some command would be triggered (WS.Activate ?) to put the focus back to the worksheet.

Would that work?