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/

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/

Thanks for your quick response - however, if I need to enter the name of
the document that I need it to open. Where would I enter the detail.

I am not a VBA programmer, so bear with me!!!

Thanks


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

You can learn by using the macro recorder and then modifying to suit.
If you already have some code, copy/paste here for comments.

--
Don Guillett
SalesAid Software

"aly1cat " wrote in message
...
Thanks for your quick response - however, if I need to enter the name of
the document that I need it to open. Where would I enter the detail.

I am not a VBA programmer, so bear with me!!!

Thanks


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