Inscrit le: 04 Oct 2017
|Posté le: Lun 27 Nov - 16:28 (2017) Sujet du message: protectsheet problems: alternatives / solutions?
I'm working on a complex Excel-VBA implementation with many sheets (so many 'protectsheet' calls are present in this VBA code). As of Excel 2013 the protectsheet command became very slow, hence this tool is completely unusable in 2013.
Are there any possible alternatives/solutions to get around this problem? I already tried a protectsheet userinterfaceonly but due to the complexity of the sheets this gave other problems; not protecting the sheets is not an option.
I didn't find the right solution from the Internet.
Animated sales explainer