Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes it is, try this:-
Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Intersect(Target, Range("A1")) If rng Is Nothing Then Exit Sub Else If Target.Value 6 Then Workbooks.Open ("C:\book2.xls") Else Exit Sub End If End If End Sub This is worksheet code so right click the sheet tab - view code and paste in. If A1 value is greater than 6 then the workbook opens. Mike "Mike" wrote: I would like Excel to automaticaly open another worksheet if the value of a particular cell has a particular value. Is this posible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|