Protected cells can not be modified

Creating a macro - Writing a Script - Using the API

Protected cells can not be modified

Postby ugurkara » Tue Sep 07, 2010 7:05 am

Normally we receive the message "protected cells can not be modified" , when trying to enter value to protected cells.
Is there any way to prevent show the msgbox?
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
ugurkara
 
Posts: 4
Joined: Sun Jun 13, 2010 10:41 am

Re: Protected cells can not be modified

Postby RoryOF » Tue Sep 07, 2010 8:08 am

Perhaps I am being obtuse, but it seems to me to be counter productive to protect cells that must be altered. Information on unprotecting selected cells is at
http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/How_do_I_protect_cells_in_my_spreadsheet%3F
Apache OpenOffice 4.0.1 on Xubuntu 14.04 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14377
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Protected cells can not be modified

Postby ugurkara » Fri Sep 10, 2010 7:32 pm

Dear rory,
my aim is to prevent the user edit the cells. sure, we can use protection . But i don't want any message box.
Mightbe i need to prevent the user select any cell before editing. I'm not sure. I can't find any hint all forum about it.
how to disable selection any cell or editing cell without messagebox?
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
ugurkara
 
Posts: 4
Joined: Sun Jun 13, 2010 10:41 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 4 guests