Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro: Speak on enter
I am attempting to create an excel macro that would "read"
a cell when a hyperlink is pushed. The macro is easily recorded (eg. enter) and when the hyperlink that is associated with the macro pushed I can see the cell move but there is no "voice" reading the cell. The macro script is: sub read_cell() ' 'read_cell Macro 'Macro recorded 8/29/204 by Gary A . Peitzmeier M.D. ' ' ActiveCell.Select End Sub It appears that the macro is set to go to the cell below the active cell (eg my enter) but without the "enter" command in the macro it will not read the text. Is there anyway to set up this macro without learing about visual basic? If not possible is there any way that I could associate a picture with a Function key (I have a separate program that can be used to create macros that I could associate with a function key. The reason that I am doing this is to try to use a tablet computer with only a stylus rather than needing a keyboard for keyboard shortcuts. thanks in advance. If you could e-mail a solution to I would be most apprecative. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro: Speak on enter
I added a hyperlink to a worksheet via Insert|Hyperlink--I didn't use the
=hyperlink() worksheet function. Then I could rightclick on the worksheet tab and select view code. I pasted this in the code window: Option Explicit Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) On Error Resume Next Application.Speech.Speak Target.TextToDisplay On Error GoTo 0 End Sub Gary Peitzmeier wrote: I am attempting to create an excel macro that would "read" a cell when a hyperlink is pushed. The macro is easily recorded (eg. enter) and when the hyperlink that is associated with the macro pushed I can see the cell move but there is no "voice" reading the cell. The macro script is: sub read_cell() ' 'read_cell Macro 'Macro recorded 8/29/204 by Gary A . Peitzmeier M.D. ' ' ActiveCell.Select End Sub It appears that the macro is set to go to the cell below the active cell (eg my enter) but without the "enter" command in the macro it will not read the text. Is there anyway to set up this macro without learing about visual basic? If not possible is there any way that I could associate a picture with a Function key (I have a separate program that can be used to create macros that I could associate with a function key. The reason that I am doing this is to try to use a tablet computer with only a stylus rather than needing a keyboard for keyboard shortcuts. thanks in advance. If you could e-mail a solution to I would be most apprecative. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro: Speak on enter
Thanks for your quick reply.
I tried your code and it works to make the cell "speak" but unfortunatly the hyperlink function causes the focus to move to cell A1 (which is the cell I assigned to the hyperlink) What I really want to do is assign a macro or hyperlink to a "word art" picture at the top of the spreadsheet that when clicked will delete the cell that is in focus then move down to the cell below and "read" that cell. A 2nd "button" would change the formatting of the cell that is in focus and "read" the cell below (eg push one work art button, labeled completed, to remove an item from a checklist and read the next item while pushing a 2nd button, labeled "deferred", to highlight a skipped item of the checklist while moving on to the next item) If you can help me that would be greatly appreciated. Gary Peitzmeier *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro: Speak on enter
I'm kind of confused.
When you delete a cell (whole row???), the activecell "moves". Then drop down one row and say that? Option Explicit Sub testme() ActiveCell.EntireRow.Delete 'or 'ActiveCell.Delete shift:=xlUp '??? 'activecell is now in the cell that was below On Error Resume Next Application.Speech.Speak ActiveCell.Offset(1, 0).Text On Error GoTo 0 End Sub (I don't think you're going to be able to use a hyperlink to do all this.) Gary Peitzmeier wrote: Thanks for your quick reply. I tried your code and it works to make the cell "speak" but unfortunatly the hyperlink function causes the focus to move to cell A1 (which is the cell I assigned to the hyperlink) What I really want to do is assign a macro or hyperlink to a "word art" picture at the top of the spreadsheet that when clicked will delete the cell that is in focus then move down to the cell below and "read" that cell. A 2nd "button" would change the formatting of the cell that is in focus and "read" the cell below (eg push one work art button, labeled completed, to remove an item from a checklist and read the next item while pushing a 2nd button, labeled "deferred", to highlight a skipped item of the checklist while moving on to the next item) If you can help me that would be greatly appreciated. Gary Peitzmeier *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
speak cells in Excel | Excel Discussion (Misc queries) | |||
I cannot CANCEL 'Speak Cells on Enter' | Excel Discussion (Misc queries) | |||
how to get excel to speak to me | Setting up and Configuration of Excel | |||
Where has 'speak on enter' gone? | Excel Discussion (Misc queries) | |||
How can I make Excel speak? | Setting up and Configuration of Excel |