I am new to this forum and thanks to all who read this post.
I have created a custom ribbon for an Excel spreadsheet and have the following problem when I break/step any macro in VBA:
If I put in a break point in a macro and then abort the macro when the execution reaches that point my ribbon bar no longer works. As I mouse over I get all sorts of errors stating that variables are out of range etc. I have to restart Excel and then the ribbon bar works fine. Here are the steps I do to create this problem:
1. create a custom ribbon complete with callbacks and macros that are called for each callback
2. open the excel file and access the vba editor
3. open any macro and put in a break point
4. run the macro
5. when the macro gets to the break point, stop the macro.
6. If I return to Excel, my ribbon bar no longer works.
The macros I try to break and then abort have nothing to do with the custom ribbon and aren't even called by the ribbon.
Not a huge problem but a little annoying that every time I try to troubleshoot a macro I have to restart Excel.
BTW:
1. I am running Windows XP SP3
2. I am using Office 2010 but this happens in Office 2007 as well
I have created a custom ribbon for an Excel spreadsheet and have the following problem when I break/step any macro in VBA:
If I put in a break point in a macro and then abort the macro when the execution reaches that point my ribbon bar no longer works. As I mouse over I get all sorts of errors stating that variables are out of range etc. I have to restart Excel and then the ribbon bar works fine. Here are the steps I do to create this problem:
1. create a custom ribbon complete with callbacks and macros that are called for each callback
2. open the excel file and access the vba editor
3. open any macro and put in a break point
4. run the macro
5. when the macro gets to the break point, stop the macro.
6. If I return to Excel, my ribbon bar no longer works.
The macros I try to break and then abort have nothing to do with the custom ribbon and aren't even called by the ribbon.
Not a huge problem but a little annoying that every time I try to troubleshoot a macro I have to restart Excel.
BTW:
1. I am running Windows XP SP3
2. I am using Office 2010 but this happens in Office 2007 as well