Can a User Defined Function in a cell be executed by a click on that cell?

mikek6mkf

New member
Joined
Mar 2, 2015
Messages
2
Reaction score
0
Points
0
Hi Folks,

I am the newest of newbies working with VBA programming and Excel.

I have a matrix of cells, each of which is filled with variations of this:

=OpenPDF("C:\Users\Mike-K6MKF\Desktop\...\01-Mar-2015_14-55-47_UTC_80.pdf",12,,"none",1,0,0,0,0)

I found the OpenPDF UDF on the web to allow me to open a specific page in a .pdf file, and it's working just the way I want it to. The example above will allow me to open page 12 of this .pdf file.

In order for each cell to perform the OpenPDF function, I must now click on the cell, click the cursor into the edit field, the click the 'check' mark and the OpenPDF will open up the correct page for me.

What I'm looking for is a way, either in this workbook, or another workbook, to 'execute' the contents of a given cell when clicked, without the machinations of a 'fake edit'.

Any and all suggestions will be greatly appreciated!!

Thanks!
 
Or am I going about this the wrong way?

Here's my matrix. Each cell contains the function call shown above, to display a specific page in a specific document:

func matrix.JPG
 
Back
Top