+ Reply to Thread
Results 1 to 8 of 8

Speak cell macro freezes sheet & doesn't allow other tasks

  1. #1
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Speak cell macro freezes sheet & doesn't allow other tasks

    I have few macros which perform some actions every few minutes. One of them is speak cells, which runs every 30 seconds. But it freezes my sheet till the time the action isn't completed. So my other macros stop working for that time.

    Is there a way in which my speak cell macro doesn't freeze my sheet & let me perform other tasks in my sheet? The macro which im using for speak cells is the following.

    Please Login or Register  to view this content.
    Last edited by Sarangsood; 09-07-2020 at 04:16 AM.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    I do not see Excel speaking in your macro
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    Quote Originally Posted by kev_ View Post
    I do not see Excel speaking in your macro
    sorry wrong macro pasted. updated.
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    Does your workbook contain other timer macros?
    Is your data being auto-refreshed from the internet?

    What happens when ....
    Create a new workbook which only contains your speak macros
    - it works correctly for me
    - it does not freeze the workbook for me

    Do you see the same behaviour in a new workbook?

  5. #5
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    Quote Originally Posted by kev_ View Post
    Does your workbook contain other timer macros?
    Is your data being auto-refreshed from the internet?

    What happens when ....
    Create a new workbook which only contains your speak macros
    - it works correctly
    - it does not freeze the workbook

    Do you see the same behaviour in a new workbook?
    Yes other timer macros are there which copy/paste some values every few minutes.
    There is live stock prices feed also going on.

    It happens also when i create a new workbook which has only this macro.

    I think the problem lies with the speak function, which when activated doesn't allow any other task to function. That's why wanted to know from experts, how it can be overcome.

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    It happens also when i create a new workbook which has only this macro
    Did you close all other workbooks?

  7. #7
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    Quote Originally Posted by kev_ View Post
    Did you close all other workbooks?
    Yes with single workbook also it happens

  8. #8
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Speak cell macro freezes sheet & doesn't allow other tasks

    Try to use a different trigger
    Disable your timer and test this method

    Place code in code window of sheet which contains the data being refreshed

    Please Login or Register  to view this content.
    Do changes in worksheet values trigger "speak"
    - if not, put formula =Today() in any empty cell in that sheet (volatile formulas trigger Worksheet_Calculate whenever sheet values are amended)

    We can reduce the number of triggers if "speak" occurs too frequently

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-28-2019, 03:41 PM
  2. Sheet freezes when my macro copy and pastes value
    By Sarangsood in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-29-2019, 08:17 AM
  3. Speak - Speech - Speak numbers individually
    By BDD2015 in forum Excel General
    Replies: 8
    Last Post: 03-23-2017, 08:32 PM
  4. If file path doesn't exist excel freezes
    By Harribone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2015, 01:36 PM
  5. Macro code where a cell freezes on the basis of values in other cell
    By vikash200418 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2014, 02:55 PM
  6. [SOLVED] Speak from specific cell value
    By Rufles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2014, 08:51 AM
  7. Macro that generates new work sheet with people and tasks they perform
    By afniz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2013, 08:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1