Rixn
Board Regular
- Joined
- Jun 4, 2005
- Messages
- 119
- Office Version
- 2021
- Platform
- Windows
I have a cell (B1) in the second Sheet.
It contains two sentences of text,
which will be spoken when entering that Sheet (by a click in the previous Sheet).
When the Speak command is running no other user interaction can be made.
As the text is quite long not all the users want to wait until it is finished.
So I need the users to be able to click on the "Next" button which takes them to the next Sheet (and start speaking the text there).
Is there a way to solve this issue?
It contains two sentences of text,
which will be spoken when entering that Sheet (by a click in the previous Sheet).
Code:
Sub ButStart_Click()
Sheets(2).Select
Range("B1").Speak
End Sub
As the text is quite long not all the users want to wait until it is finished.
So I need the users to be able to click on the "Next" button which takes them to the next Sheet (and start speaking the text there).
Is there a way to solve this issue?