View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default What versions have userprotected rows/columns restiction etc?

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" wrote in message
...
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