Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#If #else #endif
Hello,
I have to protect a worksheet. The kind of protection must depend on the excel-version, because I have several customers with different versions of Office. First I tried with if-else-endif, but got a runtime error with O 2000, because the "AllowFormatting" is not available in O 2000. Then I tried with the #if-#else-#endif condition, but this doesn't work. I tried: Ver = CCur(Application.Version) #If Ver = 10 Then pwTab.Protect UserInterfaceOnly:=True, _ Password:=Pw, _ AllowFormattingColumns:=True, _ AllowFormattingCells:=True #Else pwTab.Protect UserInterfaceOnly:=True, _ Password:=Pw #End If Then I read the help and it says I have to use a special constant #const, but how should I get the "Application.Version" into a constant? ________________________________________ Carl-Rainer Zeiss EDV System-Beratungen Lohrgasse 11, D-60389 Frankfurt Tel: +49 69 90478774 Fax: +49 1212 66666111222 Mail: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to end my macro in If-else-Endif | New Users to Excel | |||
#if-then-#elseif-#endif | Excel Programming | |||
optimize cycle's speed - For, Next or DO, UNTIL; IF-THEN, ENDIF or CASE, ENDCASE | Excel Programming |