1. Use a worksheet_change event
right click sheet tabview codeleft window select worsheetright window
select worksheet_changetype in

if target.address<"$A$4" then exit sub
if ucase(target)="Y" or ucase(target)="YES" then call mymacro
=====


--
Don Guillett
SalesAid Software

"aly1cat " wrote in message
...
I am trying to do two things.

1. create a link in a spreadsheet whereby if the cell contains a Y or
someone enters Y (Yes). It will automatically run a program to open a
specific document or spreadsheet.

I would be grateful for some step by step instructions.

2. How do I create buttons and then add a link/macro to it, so that it
performs an action such as opening up a document?

Would appreciate any help, thanks all.


---
Message posted from http://www.ExcelForum.com/