Automatically execute a macro

[Harry]

Hi all,
I know absolutely nothing about VBA programming but would like to
make my excel spreadsheet a bit more stylish and slick.
I have a macro that opens a file and selects a specific worksheet that
I need to goto.
I would like to do this when mouse clicking on a specific cell.
I don't know how to reference a cell and I don't know how to execute a
macro when the cell has been selected.
Any help would be much appreciated.
Harry.

 

[Guest]

Hi
as a starting point:
http://cpearson.com/excel/events.htm

 

[Tom Ogilvy]

Perhaps the selectionchange event.

See Chip Pearson's page on Events

http://www.cpearson.com/excel/events.htm

Post back with specific followup questions.