Results 1 to 9 of 9

ontime macro button activates all sheets in woorkbook intead of just the one it is pressed

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    bradford
    MS-Off Ver
    Excel 2010
    Posts
    92

    ontime macro button activates all sheets in woorkbook intead of just the one it is pressed

    Hi

    Please see example wb

    I have a command button on all sheets (only 2 on the test but will have 31)
    My problem is that when i press ths start time button it starts the time ok but if i go to another sheet the time will start automatically on these sheets
    even on the data sheet which does the macros head in!!!!!

    How can i name each sheet or button to only make them work if they are pressed so other sheets could be viewed without the clock starting??
    There are other cells/codes looking at the time cell to use a count down etc

    Thanks for any help on this

    Peter
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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