J
johkur
I wonder if anyone else is having this problem. I created some files
from scratch in Excel 2007, added macros and a user-defined function,
and protected all of the worksheets and the workbook. When I went to
use the file, none of the macros worked and the function returned an
error. My trust settings are set to allow macros to run freely. I went
back and removed all of the protections and the macros then worked OK.
Is there some kind of an issue that prevents macros from running when
protections are turned on. I really need both in my files. Is there
something I'm missing here?
from scratch in Excel 2007, added macros and a user-defined function,
and protected all of the worksheets and the workbook. When I went to
use the file, none of the macros worked and the function returned an
error. My trust settings are set to allow macros to run freely. I went
back and removed all of the protections and the macros then worked OK.
Is there some kind of an issue that prevents macros from running when
protections are turned on. I really need both in my files. Is there
something I'm missing here?