Hi,
I'm using Excel 2007 and I've spent a number of days to figure this out and it just keeps on popping up despite my best efforts.
I've written a number of functions and subs that work when I change combo boxes as they should. When I think I'm done and then I try and save as, save or just close excel is calling and updating all the combo boxes and giving me errors that didn't appear when I called them as desired.
The specific error I'm getting now is
"Cannot update. Database or object is read-only."
This error is coming from a function I wrote that returns a string by querying a worksheet. I'm happy to give you more details or code that I have but I was wondering what if anyone has run into this and can give me an idea on how to shut these things down when I'm not using them!
FYI - I have tried to set global subs like Private Sub Workbook_BeforeClose(Cancel As Boolean) to return a true flag and not run the code when it is closing but even that isn't working. This might be lack of knowledge on my part but it seems that this is a bug or bigger problem. If it's a bug, I don't mind but I do would like a workaround!
Thank you in advance for any insight or thoughts you have on the subject. It's much appreciated!
- Brendan
I'm using Excel 2007 and I've spent a number of days to figure this out and it just keeps on popping up despite my best efforts.
I've written a number of functions and subs that work when I change combo boxes as they should. When I think I'm done and then I try and save as, save or just close excel is calling and updating all the combo boxes and giving me errors that didn't appear when I called them as desired.
The specific error I'm getting now is
"Cannot update. Database or object is read-only."
This error is coming from a function I wrote that returns a string by querying a worksheet. I'm happy to give you more details or code that I have but I was wondering what if anyone has run into this and can give me an idea on how to shut these things down when I'm not using them!
FYI - I have tried to set global subs like Private Sub Workbook_BeforeClose(Cancel As Boolean) to return a true flag and not run the code when it is closing but even that isn't working. This might be lack of knowledge on my part but it seems that this is a bug or bigger problem. If it's a bug, I don't mind but I do would like a workaround!
Thank you in advance for any insight or thoughts you have on the subject. It's much appreciated!
- Brendan