User Defined Functions

G

Guest

Hi,

I've designed a user defined function which adds cells in range dependent on
their font colour. The VBA behind the function works very well.

However when I change the font colour of a cell the function does not
automatically run. Only when I open and close the workbook does the function
run updating the totals.

Punching F9 to get the workbook to calculate does no good and neither will
trying to run the functions from within the VBA editor...

Any help is appreicated...Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple User Defined Categories in Insert Function Form 2
User Defined Function being called by changes to an independent workbook 13
user defined functions 2
User Defined Function Not Does Not AutoCalc 4
Editing user defined functions 5
Refreshing user defined functions 3
excel spreadsheet functions written in vba 1
multiple user-defined functions in add-in (2007) 2

Top