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

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

I meant

Right click the sheet tab of the worksheet you want to call the macro, view
code and paste this in.

"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

Thanks Mike, it seems to work but when i click the tab it goes to the tab
where it is to do the macro function and the screen flashes for 5 or 10
seconds and then it comes back as it should. i do not understand it.
--
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

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

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

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

It will do that because you asked for that

I want one particular macro to run each time a particular tab is clicked.

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

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

As i said i know i am green. How do i make it run the macro only once and
land back on my tab without running it again and again? I hate to be a bother
here and do appreciate your help to a green horn.
--
David


"Mike H" wrote:

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

It will do that because you asked for that

I want one particular macro to run each time a particular tab is clicked.

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

Hi,

Simplify your macro to this, it's selecting the sheets and then re-selecting
BID that causes the macro to execute twice

Sheets("LOG IN").Range("BG5").FormulaR1C1 = "=NOW()"

Mike

"D@SE" wrote:

As i said i know i am green. How do i make it run the macro only once and
land back on my tab without running it again and again? I hate to be a bother
here and do appreciate your help to a green horn.
--
David


"Mike H" wrote:

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

It will do that because you asked for that

I want one particular macro to run each time a particular tab is clicked.

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

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

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

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"D@SE" wrote in message
...
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

Thanks for all your help Mike, that works very good.
--
David


"Mike H" wrote:

Hi,

Simplify your macro to this, it's selecting the sheets and then re-selecting
BID that causes the macro to execute twice

Sheets("LOG IN").Range("BG5").FormulaR1C1 = "=NOW()"

Mike

"D@SE" wrote:

As i said i know i am green. How do i make it run the macro only once and
land back on my tab without running it again and again? I hate to be a bother
here and do appreciate your help to a green horn.
--
David


"Mike H" wrote:

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

It will do that because you asked for that

I want one particular macro to run each time a particular tab is clicked.

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