| View previous topic :: View next topic |
| Author |
Message |
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
 Posted: Mon Feb 13, 2006 3:26 pm Post subject: spreadsheet protection |
 |
|
I developped a complex spreadsheet and want to protect it and want to restrict the usage of a desktop( not a person).
What would be my best approach ? |
|
| Back to top |
|
 |
RonIA
Super User
Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA
|
| Posted: Thu Feb 16, 2006 10:32 am Post subject: |
|
|
Take a look at Tools - Protect
This will give you the option to prevent changes from being made. If this isn't what you were looking for, please let us know.
_________________
Ron from Iowa, USA |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Tue Feb 21, 2006 9:57 am Post subject: Tools=Protect |
|
|
Hi Ron,
no the protect function is not what I look for.
"Protect" don' protect the spreadsheet to be copied nor to used from somebody else.
I need a protection which limit the usage of the spreadsheet of one desktop or laptop.
Is it possible to read the administrator name (windows) from Calc ?
If it is possible I could protect the sheet by comparing the administrator name with the a name saved in the spreadsheet.
Have you an other suggestion ?
Michel |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Tue Feb 21, 2006 10:28 am Post subject: Re: Tools=Protect |
|
|
| mdkmemphis wrote: | Hi Ron,
no the protect function is not what I look for.
l |
Windows?
Save As, then look in the Save dialogue window upper right for "Tools". There you can password protect to open or not after saving. However, I will add [again] that there is no such thing as foolproof security. Hackers get into the Pentagon files in minutes. You don't stand a chance. All you can do is the best you can do.
David. |
|
| Back to top |
|
|
RonIA
Super User
Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA
|
| Posted: Tue Feb 21, 2006 10:41 am Post subject: |
|
|
Sounds like you might also be looking at something that is an operating system function not the function of OO.o.
_________________
Ron from Iowa, USA |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Tue Feb 21, 2006 11:33 am Post subject: sheet protection |
|
|
Hi Guys!
Can I call a procedure from CALC ?
Michel |
|
| Back to top |
|
|
RonIA
Super User
Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA
|
| Posted: Tue Feb 21, 2006 12:15 pm Post subject: Re: sheet protection |
|
|
| mdkmemphis wrote: | Hi Guys!
Can I call a procedure from CALC ?
Michel |
Michel,
I would guess the answer is yes, however possibly a better description of what exactly you are trying to accomplish would be helpful.
For example, only certain people can open the file for viewing, others can open the file for editing. If however the control extends to some people can not even see the file exists on the computer, or can not delete the file from the computer, etc. would be very different.
_________________
Ron from Iowa, USA |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Tue Feb 21, 2006 2:04 pm Post subject: sheet protection |
|
|
Hi Ron,
what I try to accomplish is to protect the sheet to be used in other PC .
That mean I want to restrict the usage of the sheet in PC which I know.
That is the reason why I mentioned before the possibility to read the administrator name and to compare with a name located in the sheet. If it is not identical the sheet can not be used.
You maybe have an other idea.
Michel |
|
| Back to top |
|
|
RonIA
Super User
Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA
|
| Posted: Tue Feb 21, 2006 2:25 pm Post subject: |
|
|
As stated, if you do check the "Save with Password" option when you do a Save As, you will be prompted for the password to be able to access the document when you open it. This would be the simplest option. Then the only person able to access the file would be those you have shared the password with.
_________________
Ron from Iowa, USA |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Wed Feb 22, 2006 8:45 am Post subject: save as |
|
|
Hi Ron,
I understand, but the protection is not good rnough.
Can I from Calc call a extern VP procedure ?
If yes how ?
Michel |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Wed Feb 22, 2006 9:30 am Post subject: other issues |
|
|
Hi Ron,
where can I find some information how to created dialog boxes by opening the sheet.
The help file is not deep enough.
Michel |
|
| Back to top |
|
|
RonIA
Super User
Joined: 28 Sep 2004
Posts: 925
Location: Iowa, USA
|
| Posted: Wed Feb 22, 2006 6:41 pm Post subject: |
|
|
You might want to search through the OpenOffice.org Macros and API forum instead of Calc for that type of information. I have not had much of an opportunity to do macro programming in OO.o yet.
I do see there is an event for Open Document so it should be able to call an external procedure from that event, but I unforuntately do not have the expertise to help you out from here. I hope you find someone with more MS VP background to help you further.
_________________
Ron from Iowa, USA |
|
| Back to top |
|
|
mdkmemphis
General User
Joined: 13 Feb 2006
Posts: 14
|
| Posted: Wed Feb 22, 2006 9:31 pm Post subject: spreadsheet protection |
|
|
| Thanks Ron ! |
|
| Back to top |
|
|
|
