Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Restiction of cell value | Excel Worksheet Functions | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) |