#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"