Thanks Don that works great!
--
David


"Don Guillett" wrote:

Put in the sheet code of the BID sheet by right click sheet tabview
codecopy/paste this.
Now, each time you activate the BID sheet it will check to see if the cell
matches today's date. If so, it does nothing. If not, it enters today's
date. Is this what you want?

Private Sub Worksheet_Activate()
With Sheets("LOG IN").Range("BF5")
If .Value < Date Then .Value = Date
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"D@SE" wrote in message
...
Thanks for your help. When i click on tab titled "BID" , it is to go run a
macro titled "NOW" which puts the date on tab "LOG IN" in cell BF5 and
then
returns to tab "BID". Here is my code, '
Sheets("LOG IN").Select
Range("BF5").Select
ActiveCell.FormulaR1C1 = "=NOW()"
Range("BG5").Select
Range("E11:E12").Select
Sheets("BID").Select
End Sub
thank you so much
--
David


"Mike H" wrote:

Hi,

It will only call your code once but without seeing what your code is I
think the best solution might be

Sub YourSub()
Application.screenupdating=false

'Your code

application.screenupdating =true
end sub

Mike

"D@SE" wrote:

i think every time it comes back to my tab it is trying to run through
the
whole process again and again.
--
David


"Mike H" wrote:

Hi,

Right click the sheet tab of the worksheet you want to call the macro
and
paste this in. I've assumed you macro is in a general module. Change
MySub to
the name of your sub

Private Sub Worksheet_Activate()
Call MySub
End Sub

Mike


"D@SE" wrote:

I am kind of green here. I have various macros in a workbook and i
want one
particular macro to run each time a particular tab is clicked. i
have read
other similar questions and responses and can not seem to follow. i
guess i
need a little more detail. Thank you so much.
--
David