Dear all
We are executing certain simulations in excel based applications. I am encountering two issues. I have searched a lot but could not find any satisfactory response. Here are the problems:
1. The code runs very slow in Excel 2007 and it runs fine in Excel 2003. Number of users have reported the same problem but no satisfactory response.
2. Second point is a thought of mine. I am just a beginner in VB but I would like to ask if we can restrict the events to the grid only?? I mean if I lock, it locks the entire sheet via events. Can event be triggered only for my data grid in the sheet?
This is urgent!!
Please reply !!
Regards
Gajendra
We are executing certain simulations in excel based applications. I am encountering two issues. I have searched a lot but could not find any satisfactory response. Here are the problems:
1. The code runs very slow in Excel 2007 and it runs fine in Excel 2003. Number of users have reported the same problem but no satisfactory response.
2. Second point is a thought of mine. I am just a beginner in VB but I would like to ask if we can restrict the events to the grid only?? I mean if I lock, it locks the entire sheet via events. Can event be triggered only for my data grid in the sheet?
This is urgent!!
Please reply !!
Regards
Gajendra