Last Modify Date

[waterballoon]

I am trying to have a cell in each of my tabs show the last date that each respective tab was modified...is this possible?

Thanks in advance...

 

[waterballoon]

Is your above code for the workbook or for each worksheet?

 

[Jaafar Tribak]

Is your above code for the workbook or for each worksheet?

That's for the workbook so that it works for every worksheet.

 

[waterballoon]

And if I wanted to do that for each worksheet (worksheets are modified separately on different days).

I think I begin by selecting the specific sheet instead of ThisWorkbook, but after that I'm a bit lost...

Thanks

 

[Jaafar Tribak]

And if I wanted to do that for each worksheet (worksheets are modified separately on different days).

I think I begin by selecting the specific sheet instead of ThisWorkbook, but after that I'm a bit lost...

Thanks

No. the code in the workbook module will work for every worksheet as is.
You don't need to have code in each worksheet to achive what you want.

Try the code in a blank workbook and see what happens .

 

[waterballoon]

THANK YOU!

You are too good at this stuff.

Much appreciated!

 

[Jaafar Tribak]

THANK YOU!

You are too good at this stuff.

Much appreciated!

Thanks for the feedback - glad I could help.