RE: $$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Dave Bonallack
Oops and: If Activeworksheet.Name = "Main" Then From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Workbook.Selection Change Event Date: Fri, 22 Jan 2010 12:52:44 +0800 Hi, Try: Private Sub Workbook_SheetActivate(ByVal Sh As Ob

RE: $$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Dave Bonallack
Hi, Try: Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dave. Date: Thu, 21 Jan 2010 23:18:50 +0530 Subject: $$Excel-Macros$$ Workbook.Selection Change Event From: harpreetguj...@gmail.com To: excel-macros@googlegroups.com Hi, Need help regarding the following code: I have written

$$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Harpreet Singh Gujral
Hi, Need help regarding the following code: I have written a code which would help me to determine Which sheet is the user on, and if that matches the criteria, then the statement would be executed. I believe, that i am not able to make the macro identify which sheet is the User on. Code: Priva