EXCEL: Issue with formula =CELL(63, 'sheet1'!A1)
cuci34
-
tontong Posted messages 2575 Registration date Status Membre Last intervention -
tontong Posted messages 2575 Registration date Status Membre Last intervention -
Hello,
I would like to count the number of cells of a certain color. For this, I used the function =INFO.CELL(63; 'sheet1'!A1) in Edit --> Name --> Define.
Everything works perfectly.
But the problem is that when I save and close the file and reopen it, the following message appears: "This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or harmful code and they will be disabled."
As a result, my formulas no longer work. Where does this come from?
Thank you in advance for your help.
I would like to count the number of cells of a certain color. For this, I used the function =INFO.CELL(63; 'sheet1'!A1) in Edit --> Name --> Define.
Everything works perfectly.
But the problem is that when I save and close the file and reopen it, the following message appears: "This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or harmful code and they will be disabled."
As a result, my formulas no longer work. Where does this come from?
Thank you in advance for your help.