+ Reply to Thread
Results 1 to 2 of 2

Alarm sounds when switching sheets & opening another workbook

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Alarm sounds when switching sheets & opening another workbook

    As a preliminary I should say I know absolutely nothing about computer programming and therefore nothing about the programming that excel uses.

    Anyway I downloaded this software about a week or so ago (Gruss which interfaces with the website betfair). I'm using it to link the odds from the Betfair site into an excel spreadsheet -- so that when the odds change the numbers change in the appropriate linked cells in excel. I wanted an alarm to go off when the odds exceed a certain value. This value I have placed in another cell. I did a search on the net and used the following code:

    http://j-walk.com/ss//excel/tips/tip87.htm

    Wouldn't work at first -- I just pasted the code in the first window that came up in the programming area. But then I inserted a module and pasted it in that, and now it works with the alarm sounding continuously (looping) when a value in a cell in another sheet linked to the back odds exceeds a value in another cell.

    In cell A1 in sheet1 I have =alarm(C1,">B1")
    In cell B1 is just a number which I can manually alter.
    In cell C1 I have =Sheet2!$F$5

    Sheet 2 is where the betfair match odds of a soccer match are imported with cell F5 being the back odds of the home team.

    Anyway when cell A1 says false the alarm will go off when I switch to another sheet, or when I open another workbook. It only stops when I go back to the original sheet.

    Does anyone have any suggestions as to what is possibly going wrong here? I have zero understanding of the code, but have nevertheless experimented with it, but to no avail. I conclude that computer programming seems to be resistant to an experimental approach in the absence of any understanding of the language!

    Any help from anyone would be gratefully appreciated. But any help I'm afraid needs to be extraordinarily simplified so I can follow it.

  2. #2
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Alarm sounds when switching sheets & opening another workbook

    A few people have looked at this without anyone responding. This might imply that the problem is not so obvious and straightforward as I assumed?

    OK I'm trying to upload the file although don't know if it's worked. But obviously since it won't be linked to the Gruss software the problem won't be able to be replicated. But hopefully someone can see what the problem is?

    What about altering the code so that the alarm only sounds once? (linked to Gruss the alarm sounds continuously until I alter the value of B1, or if I simply open another worksheet whilst cell A1 on sheet1 still says "false"). Would that work, and how would I do it?
    Attached Files Attached Files

+ 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. Audible alarm without even opening the workbook
    By mole_man in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 09:26 AM
  2. [SOLVED] Refreshing/Recalculating Sheets based on user input or switching between sheets
    By SonOfOdin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 09:48 PM
  3. switching work sheets within a workbook
    By rrchadde in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2010, 11:37 PM
  4. Opening a workbook then switching back to first workbook
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-26-2009, 03:38 AM
  5. Playing sounds on opening a worksheet or shortcut
    By MusicusMalus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2005, 04:06 PM

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