LinkBack URL
About LinkBacks
Hi,
I have a workbook which contain private sub sheet change (located at Thisworkbook). I will like to stop using this private sub on specific worksheet (sheet3) and I don't know what is the method to make it happen.
Please help
BR
KC
Hi,
I have a workbook which contain private sub sheet change (located at Thisworkbook). I will like to stop using this private sub on specific worksheet (sheet3) and I don't know what is the method to make it happen.
Please help
BR
KC
You can place this macro in a specific sheet so it will only be activated by a change to this sheet.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
If you wanted this event to continue working on every sheet except sheet3, you could leave the sub in the ThisWorkbook module and just test the sheet name before actually doing anything...
Please Login or Register to view this content.
Hi rnamahoe,
I find out that this code that you provide:
need to change the sheet3.name to "sheet3"PHP Code:Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name <> Sheet3.Name Then
'Do Something
End If
End Sub
ThanksPHP Code:Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name <> "sheet3" Then
'Do Something
End If
End Sub
BR
KC
Last edited by alexnkc; 02-20-2013 at 09:34 PM. Reason: typo error (from ' to "")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks