keldsor
Board Regular
- Joined
- Jun 9, 2017
- Messages
- 52
I have a workbook with a worksheet with a lot of shapes like DOT.
Each dot represents an event and I can get the details for a specific event shown in Word by double clicking on the DOT for the event I want to see the details for.
I HAVE to do "double clicking" for the details to show up in Word AND bring Word in front on the screen, BUT ...
unfortunately this "double clicking" takes Excel out of "Selecting objects"-mode and inte "Selecting cells"-mode !
When I opens the workbook I have this code to secure it opens in "Select objects"-mode:
How can I sort of "lock the workbook in that "Select-Objects-mode" ?
Each dot represents an event and I can get the details for a specific event shown in Word by double clicking on the DOT for the event I want to see the details for.
I HAVE to do "double clicking" for the details to show up in Word AND bring Word in front on the screen, BUT ...
unfortunately this "double clicking" takes Excel out of "Selecting objects"-mode and inte "Selecting cells"-mode !
When I opens the workbook I have this code to secure it opens in "Select objects"-mode:
Code:
Private Sub Workbook_Open()
If ActiveSheet.Shapes.Count > 0 Then Application.CommandBars.ExecuteMso "ObjectsSelect"
End Sub
How can I sort of "lock the workbook in that "Select-Objects-mode" ?