Quote:
Originally Posted by macropod
Huh? What solution did Bob post?
The solution I posted works with xls and xlsm files, just not xlsx files...
|
Sorry not bob it was you. If you create an xlsx and you apply the VB as soon as you exit and go back into it you haven't got the code anymore (because its now a xlsx) and so the calculations don't work - unless Im missing something?
Again apologies for the confusion I really should read what I write
