What versions have userprotected rows/columns restiction etc?
 

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

What versions have userprotected rows/columns restiction etc?
 

I have excel 2000, it does what you ask


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522059

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

What versions have userprotected rows/columns restiction etc?
 

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" skrev
i meddelandet
...

I have excel 2000, it does what you ask


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522059