S
Soze
I want to have Excel set up such that when I try to open a file that's
greater than, say, 20 MB, I want the file to open with manual
calculate, else to open normally with automatic calculation. Is there
an easy way to achieve something like this? I tried adding a file to
the XLSTART folder with a macro that checks for file size and according
sets the manual calculation, but I can't get anything like that to work
since I can't pass to this macro the name of the file that was opened
in the first place...
greater than, say, 20 MB, I want the file to open with manual
calculate, else to open normally with automatic calculation. Is there
an easy way to achieve something like this? I tried adding a file to
the XLSTART folder with a macro that checks for file size and according
sets the manual calculation, but I can't get anything like that to work
since I can't pass to this macro the name of the file that was opened
in the first place...