Run macro if user goes to a specific worksheet
 

I have a workbook with several worksheets. There is on worksheet that I want
to run a macro on if the user of the worksheet goes to it.

Any ideas?

Run macro if user goes to a specific worksheet
 

Place the below as the first line of the macro.

If Environ("Username") < "username" Then Exit Sub

If this post helps click Yes
---------------
Jacob Skaria


"Danielle" wrote:

I have a workbook with several worksheets. There is on worksheet that I want
to run a macro on if the user of the worksheet goes to it.

Any ideas?

Run macro if user goes to a specific worksheet
 

Oops....Use the Worksheet_Activate event...Right click sheet tabView code and

Private Sub Worksheet_Activate()

End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Place the below as the first line of the macro.

If Environ("Username") < "username" Then Exit Sub

If this post helps click Yes
---------------
Jacob Skaria


"Danielle" wrote:

I have a workbook with several worksheets. There is on worksheet that I want
to run a macro on if the user of the worksheet goes to it.

Any ideas?