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/