LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Activate speech when sheet is changed

I have a sheet that is "monitoring" the status of a another sheet. When the
source sheet changes, the second sheet - named "Error"- displays a message
using a simple "If" statement.

Normally, the monitoring sheet is displaying an empty string (no message)
until the source sheet activates an error condition (0 changes to 1 for error
message activation) within the cells being monitored. When this occurs, a
message is displayed in the error sheet.

Now, I want to activate the speech functionality in "column A" over a fixed
range of cells in the error sheet so the message will be annunciated. How can
I accomplish this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activate the top of sheet AD108 Excel Worksheet Functions 2 July 30th 06 05:27 PM
Prevent code in "Sheet Activate" from running when sheet made visible from other macr Simon Lloyd[_794_] Excel Programming 10 June 21st 06 09:15 AM
sheet.activate nk Excel Programming 0 April 8th 05 05:04 PM
Return to Current Sheet in On (sheet activate) event macro Paul Moles Excel Programming 1 March 27th 05 03:16 PM
Check activate sheet efi[_7_] Excel Programming 2 October 28th 03 03:21 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"