Excel Programming

  • Thread starter Thread starter aly1cat
  • Start date Start date
A

aly1cat

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.
 
1. Use a worksheet_change event
right click sheet tab>view code>left window select worsheet>right window
select worksheet_change>type in

if target.address<>"$A$4" then exit sub
if ucase(target)="Y" or ucase(target)="YES" then call mymacro
=====
 
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
 
You can learn by using the macro recorder and then modifying to suit.
If you already have some code, copy/paste here for comments.
 
Back
Top