If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
worksheet protectoin
some one pls guide me abt the following
my workbook has 3 sheets and sharing is also enabled along with protection (range defined) when i unprotect the sheet and try to change the data in the range which i selected earlier,, it says that it cant be done due the sheet is already protected... why is that? |
#2
|
|||
|
|||
worksheet protectoin
Hi
this is one of the restriction of shared workbooks -- Regards Frank Kabel Frankfurt, Germany murtaza wrote: some one pls guide me abt the following my workbook has 3 sheets and sharing is also enabled along with protection (range defined) when i unprotect the sheet and try to change the data in the range which i selected earlier,, it says that it cant be done due the sheet is already protected... why is that? |
#3
|
|||
|
|||
worksheet protectoin
yeah got it thanks
i've to make the sheet "exclusive" in order to get it done...thanks for ur immediate reply frank..ur always very helpful "Frank Kabel" wrote: Hi this is one of the restriction of shared workbooks -- Regards Frank Kabel Frankfurt, Germany murtaza wrote: some one pls guide me abt the following my workbook has 3 sheets and sharing is also enabled along with protection (range defined) when i unprotect the sheet and try to change the data in the range which i selected earlier,, it says that it cant be done due the sheet is already protected... why is that? |
Thread Tools | |
Display Modes | |
|
|