Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Worksheet is active then...
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Worksheet is active then...
I would probably do something like this:
sub run_or_not() if ActiveSheet.Name = "Sheet1" then 'your code here else 'your alternate code here end if end sub HTH - IT_Roofer "Darin Kramer" wrote: 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Worksheet is active then...
Put this in the ThisWorkbook code module for the workbook that contains sheet("APP_D") Private Sub Workbook_Open() Dim ws As Worksheet With ActiveSheet If ws.Name = "APP_D" Then Call fix ElseIf ws.Name < "APP_D" Then MsgBox "Wrong Sheet" End If End With End Sub "Darin Kramer" wrote: 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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Worksheet is active then...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
Basic Question - How do I return the worksheet number of the active worksheet? | Excel Programming | |||
Altering code to reference the worksheet before the active worksheet | Excel Programming | |||
copy active worksheet plus another worksheet | Excel Programming | |||
macro to apply worksheet event to active worksheet | Excel Programming |