dianahowe
07-20-2007, 05:29 AM
I have written a macro which has been distributed throughout my company for different units to use.
It contains the following instruction:
ActiveSheet.Protect PassWord:=PassWd, AllowFormattingColumns:=True, AllowFormattingCells:=True
Which works fine for the majority. However, a couple of units have older versions of Excel, where AllowFormattingColumns and AllowFormattingCells are not part of the Protect method and therefore throws up an error.
Is there another way to protect sheets while still allowing format columns and cells in the older versions of Excel or should I just tell them to make business cases for newer versions?
Thanks in advance for your :help
It contains the following instruction:
ActiveSheet.Protect PassWord:=PassWd, AllowFormattingColumns:=True, AllowFormattingCells:=True
Which works fine for the majority. However, a couple of units have older versions of Excel, where AllowFormattingColumns and AllowFormattingCells are not part of the Protect method and therefore throws up an error.
Is there another way to protect sheets while still allowing format columns and cells in the older versions of Excel or should I just tell them to make business cases for newer versions?
Thanks in advance for your :help