excel - clock in and clock out system -

hi there im creating spreadsheet use clocking in , out of work , have simple wee gui set already. along have current time showing start worksheet shows on every page wondering how stop this?? sample code below: global clockon boolean

sub runclock() range("m15").value = now() if clockon = true application.ontime + timevalue("00:00:01"), "runclock" end if end sub  sub auto_open() clockon = true runclock end sub   sub stopclock() clockon = false end sub 

on top of doing macro put information onto specific page going depending on day selected drop down menu appriciated :) in maybe if statement in vba code select correct page , leave data there.

you need specify sheet putting value on; specify range, don't specify sheet. can done multiple ways, such as:

sheets(1).range("m15").value = now() 

this selects first sheet in workbook. if have multiple workbooks, need specify somehow (by referring active workbook, or name of workbook, etc.). example:

activeworkbook.sheets(1).range("m15").value = now()