PDA

View Full Version : VBA Simulating a mouse double click



ReportTeam
10-23-2008, 04:01 AM
Hi

I am pasting a worksheet which contains formulas into a workbook which contains the same named sheets but the formulas no longer work. When I double click on the cells in question the formulas become operational.

Does anyone have any ideas on how to simulate a double click in a macro?

Thanks

CCkfm2000
10-23-2008, 04:20 AM
Hi ReportTeam,

found this link might be useful to you

http://xlvba.3.forumer.com/index.php?showtopic=115

jfournier
10-24-2008, 10:19 AM
Did you try setting the cell range's formula equal to itself? I've never done that for getting a formula to work, but I know setting a range's value equal to the range's value gets Excel to re-evaluate the type of data in the cell...

georgiboy
10-24-2008, 11:26 PM
Could you post a sheet with the formulae in inactive status?