I have a workbook with two worksheets "Time In" and "Time Out". On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!

When you click "View Code" VBA Editor will open. There will be two List
Boxes at the top or the window. The one on the left will need to say
"Worksheet", if not select "Worksheet". The one on the right should say
"Change", if not select "Change".

This will get you to the code you want to see.

Ryan

"General Specific" wrote:

I have a workbook with two worksheets "Time In" and "Time Out". On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!

Is it possible that you saved the macro within one of the sheets? Open up
all the sheets/modules within the project viewer (upper left of the VBA
window) and check for the code. If it's working, it should be there.

"General Specific" wrote:

I have a workbook with two worksheets "Time In" and "Time Out". On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!

It is also possible that you used the Workbook_SheetChange which would be in
the ThisWorkbook code module. Just check them all, it is there somewhere.

"StumpedAgain" wrote:

Is it possible that you saved the macro within one of the sheets? Open up
all the sheets/modules within the project viewer (upper left of the VBA
window) and check for the code. If it's working, it should be there.

"General Specific" wrote:

I have a workbook with two worksheets "Time In" and "Time Out". On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!

On Jun 24, 11:24*am, RyanH wrote:
When you click "View Code" VBA Editor will open. *There will be two List
Boxes at the top or the window. *The one on the left will need to say
"Worksheet", if not select "Worksheet". *The one on the right should say
"Change", if not select "Change".

This will get you to the code you want to see.

Ryan



"General Specific" wrote:
I have a workbook with two worksheets "Time In" and "Time Out". *On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". *It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". *When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!- Hide quoted text -

- Show quoted text -


No.

That's the problem. I find it that way in the sheet "Time Out", but
it won't let me for "Time In".

and it still works.

On Jun 24, 11:24*am, RyanH wrote:
When you click "View Code" VBA Editor will open. *There will be two List
Boxes at the top or the window. *The one on the left will need to say
"Worksheet", if not select "Worksheet". *The one on the right should say
"Change", if not select "Change".

This will get you to the code you want to see.

Ryan



"General Specific" wrote:
I have a workbook with two worksheets "Time In" and "Time Out". *On
each of these pages, I added a Sub that checks for entry in a column
and timestamps the neighboring cell.

I can't find the Sub Worksheet_Change in "Time In". *It still works,
but I can't find the code.

When I go to View Code, I can find the Sub under "Time Out". *When I
go to "Time In" in the code window, Sub Worksheet_Change is not there.

Help!- Hide quoted text -

- Show quoted text -

Found it.

It was after 100 blank lines of code.

Sorry