Automatically open another worksheet. . .

[bokonon]

Hi,

I would like to have certain cells in my worksheet automatically cause another worksheet to open when they are populated. In other words, if you enter an "X" in one cell, the other sheet automatically opens to a related cell that you have to populate to continue. Is this possible? Any assistance will be greatly appreciated! Thanx.

[Bryan Hessey]

Hi,

I would like to have certain cells in my worksheet automatically cause another worksheet to open when they are populated. In other words, if you enter an "X" in one cell, the other sheet automatically opens to a related cell that you have to populate to continue. Is this possible? Any assistance will be greatly appreciated! Thanx.

Possibly something added to

Please Login or Register  to view this content.

with a check to see if the file is already open, if not open it.

This would trigger the 'open' to happen when change was made to the specified range.

---