Hi all, I have been getting this run time error in a dashboard I have created that I have found a bit strange.
The Dashboard it quiet complex it has macros, userformfs, functions so not easy to pin point the issue.
At first it looked like this error was caused from a subroutine that copied and pasted data in the same sheet, after doing some manipulations of the data and paste it back... so, I did find strange
this componentX can't create object as by knowledge there are no objects in this process.
Then most peculiar thing is that once this error shows up,I loose access to all the modules forms ect, all titles are there but i can't open any, none of the macro works, looks like all macros ect are gone.
This excel file is currently used from about 100 persons and this error was presented to me from a user but i also bump into it in my copy of the file..
Also, once this happens the file is cooked. This happened to from closing the file and been fine to reopen it and been corrupted, so no computer closing with the file open or
anything that I can tell that might was that cooked the file...
I was wondering if anyone had a similar experience or even better if know what is happening here...
Thank you in advance MrExcel community !
The Dashboard it quiet complex it has macros, userformfs, functions so not easy to pin point the issue.
At first it looked like this error was caused from a subroutine that copied and pasted data in the same sheet, after doing some manipulations of the data and paste it back... so, I did find strange
this componentX can't create object as by knowledge there are no objects in this process.
Then most peculiar thing is that once this error shows up,I loose access to all the modules forms ect, all titles are there but i can't open any, none of the macro works, looks like all macros ect are gone.
This excel file is currently used from about 100 persons and this error was presented to me from a user but i also bump into it in my copy of the file..
Also, once this happens the file is cooked. This happened to from closing the file and been fine to reopen it and been corrupted, so no computer closing with the file open or
anything that I can tell that might was that cooked the file...
I was wondering if anyone had a similar experience or even better if know what is happening here...
Thank you in advance MrExcel community !
