HI there,

When a user runs a macro I need the macro to check which sheet he is
running it from, if it is the specified sheet then the macro should run,
if not it shouldent.

Whats wrong with my VB below...??

Thanks

D

Sub Run_or_not

Dim ws As Worksheet

With ActiveSheet
If ws.Name = "APP_D" Then
Call fix

ElseIf ws.Name = "x" Then


End If
End With


*** Sent via Developersdex http://www.developersdex.com ***