I'm updating a 2006 timesheet app to make a 2007 version. I seem to
have a macro hidden in there somewhere that I can't find. When I enter
a time in column D this macro automatically puts today's date in column
B.

Tools -Macro - Visual Basic Editor.

By default, there shouldn't be any information in there. You may need to
double click on (This Workbook) in the top left pane if nothing shows
initially.

" wrote:

I'm updating a 2006 timesheet app to make a 2007 version. I seem to
have a macro hidden in there somewhere that I can't find. When I enter
a time in column D this macro automatically puts today's date in column
B.

The only macro I can see for this workbook is one that clears the
entries. Any idea where else this code could be hiding?

Happy New Year and thanks for any advice!

Rightclick on the worksheet tab that has this behavior and choose view code.

If it's not there, look under the ThisWorkbook module.

wrote:

I'm updating a 2006 timesheet app to make a 2007 version. I seem to
have a macro hidden in there somewhere that I can't find. When I enter
a time in column D this macro automatically puts today's date in column
B.

The only macro I can see for this workbook is one that clears the
entries. Any idea where else this code could be hiding?

Happy New Year and thanks for any advice!

--

Dave Peterson