What versions have userprotected rows/columns restiction etc?

[Maria J-son]

Hi,

In Excel 2003, when you protect sheets, you can restict the user to certain
activities, like "Not
allow to delete rows" etc. Did this came with Excel XP, Excel 2003 or? I
intend to use this and need to know what version should be critical.

If you know a version, having this, pleas make a note.

Another thing - does anybody know how the restriction behave, if you open it
with a earlier version - does it lock the whole sheet, or set it free ...?

/Regards

 

[davesexcel]

I have excel 2000, it does what you ask

 

[Doug Glancy]

It first appeared in XP. If you run it in earlier versions you'll get a
compile error. You can code around it like:

If Val(Application.Version)>=10 Then
Call Sub_With_Special_XP_Restrictive_Code
Else
' put your pre-XP code here
EndIf

I think this works because you don't get a compile error until your code
actually branches to the sub with the uncompilable code. I think. As to
what your pre-XP code would look like, I don't know.

Doug

 

[Maria J-son]

Are you sure? Dough answered it came with XP. You should be able to protect
from just insert/delete rows.

Maybe it came with a servicepack in that case? What do you have?

/Regards


"davesexcel" <[email protected]> skrev
i meddelandet
news:[email protected]...