multiple worksheet_change

Hi there can someone help. I have a sheet where I want on a worksheet change event to..... 1) convert a range of cells to uppercase 2) allow the entry in a different range of cells of time in the format hhmm (without the colon) this is what I have now but here is the problem I can only get...

I am looking for VBA code that will filter 30+ Excel tables starting with Sheet2. Each sheet will contain a table with a date range in column A starting with the header row being row 1. I am looking to enter a date into Sheet1 in cell B2. I'd like to add a Command Button to Sheet 1 to run...

Hi, I need to combine following codes which will change the attributes of the cell as well as worksheet. And I need it in single worksheet. Formula 1 Private Sub Worksheet_Change(ByVal Target As Range) If Range("I6").Value = "NO" Then Rows("52:55").EntireRow.Hidden = True...

Hello, The help I've found on this subject has been great, but now I think my problem is more specific. I have the following code applied to one worksheet (right click sheet tab and click "view code") and it works very well: Private Sub Worksheet_Change(ByVal Target As Range) If...

here is my code, and I need help either combining the two Worksheet_Change routines or getting another way to do this. Thanks in advance Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$I$2" Then Exit Sub If Target = "GB" Then ActiveSheet.Unprotect...