I believe this is true on the Mac Books, and it can really slow you down when working in Excel. Menu Key – The Menu Key can be used to convert text to numbers, ignore formula errors, and access paste options like paste values.

You can add hyperlink with ScreenTip to a certain shape in worksheet. Please do as follows. Right click the shape you need to add mouse over tip, then click Hyperlink from the right-clicking menu. See screenshot: 2. In the Insert Hyperlink dialog box, click the ScreenTip button. And in the Set Hyperlink ScreenTip dialog box, enter the screen tip text you need to display while hovering over the shape by mouse. Finally click the OK button.

See screenshot: 3. When it returns to the Insert Hyperlink dialog box, click the Bookmark button. Then enter A1 into the Type in the cell reference box of the Select Place in Document dialog box, and finally click the OK button.

Click the OK button in the Insert Hyperlink dialog box to finish the hyperlink creating. Now you can see the screen tip displaying when hovering over the shape by mouse. Add mouse over tip to a certain shape with VBA code You can easily add mouse over tip to a certain shape after running the following VBA code.

Open the worksheet contains the shape you will display tip when moving mouse over. Right click the sheet tab and then click View Code from the context menu. In the Microsoft Visual Basic for Applications window, please copy the below VBA code into the Code window.

VBA Code 1: Add mouse over tip to a certain shape Private Sub Worksheet_SelectionChange(ByVal Target As Range) ‘Updated by Extendoffice 2018/3/30 If Target.Address = Range('A1').Address Then Call MoveRow End If End Sub 3. Click Insert > Module. Then enter below VBA code into the Module window. VBA Code 2: Add mouse over tip to a certain shape Sub Text() ‘Updated by Extendoffice 2018/3/30 Dim xShape As Shape Dim xRg As Range On Error Resume Next Application.EnableEvents = False Set xShape = ActiveSheet.Shapes('Rectangle 4') If Not xShape Is Nothing Then ActiveSheet.Hyperlinks.Add xShape, ', 'A1', ScreenTip:='Click to run Macro ' End If If ActiveSheet.Hyperlinks(1).SubAddress = 'A1' Then Call MoveRow End If Application.EnableEvents = True End Sub Notes: 1). Please replace the “ Click to run Macro” and “ Rectangle 4” with your screen tip text and the name of the certain shape.

Replace ' MoveRow' in line ' Call MoveRow' to the macro name you have assigned to the shape 3. Press the F5 key to run the code. Download paragon driver for mac. Then the specified screen tip is added to the certain shape immediately. Related articles: • • •. Increase your productivity in 5 minutes. Download fl studio for free mac. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data.

• Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools. Dear Niall, Sorry for the mistake. Please try as below to solve the problem.

Step 1: In the worksheet contains the shape you will display tip, right click the sheet tab and select View Code from the context menu. And then copy below VBA into the Code window: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = Range('A1').Address Then Call MoveRow End If End Sub Step 2: Open the Module code window, copy below code into the Module window. Please change 'MoveRow' in the line Call MoveRow to the macro name you assigned to the shape, and then press the F5 key to run the code. Thank you for your comment. Sub Text() Dim xShape As Shape Dim xRg As Range On Error Resume Next Application.EnableEvents = False Set xShape = ActiveSheet.Shapes('Rectangle 1') If Not xShape Is Nothing Then ActiveSheet.Hyperlinks.Add xShape, ', 'A1', ScreenTip:='Click to run Macro ' End If If ActiveSheet.Hyperlinks(1).SubAddress = 'A1' Then Call MoveRow End If Application.EnableEvents = True End Sub.