Running a worksheet with vba, at the start of the code I turn warnings off and at the very end of the code I turn them back on.
When the routines complete a warning is raised:
OK. How? When I run Error Checking everything comes up clean.A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name, and cell reference.
Clicking on "Show Formulas" shows no formulas for there are no formulas on the sheet to show, just a chart, and clicking "Show Formulas" just turns my dates into serial numbers and screws up the display of the two comboboxes, messing the fonts and drop-down arrows, and since closing and reopening didn't revert the comboboxes back to normal I will now have to blow them away and resurrect them. Ahhhhh, and I also see Show Formulas also messed up my command buttons. nice...
The only way I find to avoid the error is to turn Warnings OFF at the start of the charting routine and NEVER turn it back on. Not a good-feeling solution.
I made certain that none of my names had any errors in them. Everything looks proper. So what next?
I fear something will create an error for me now along the lines of Murphy's Law, so I really would like to find it and knock it out before it bites me!!!
Thanks!
Bookmarks