Is there any other way to lock worksheet apart from tool, protect? I have a
workbook that I will be sharing, but apart from some cells I need it to be
locked. I realized that locking it through tool, protect is about 5% safe.

If you are looking for a way of locking a workbook that can not be hacked
then you are out of luck. Everything in XL can be hacked...
--
HTH...

Jim Thomlinson


"Link" wrote:

Is there any other way to lock worksheet apart from tool, protect? I have a
workbook that I will be sharing, but apart from some cells I need it to be
locked. I realized that locking it through tool, protect is about 5% safe.

Thats good news!!! So, is there any other way to lock certain cells apart
from tool, protect? Just want to know.
"Jim Thomlinson" wrote:

If you are looking for a way of locking a workbook that can not be hacked
then you are out of luck. Everything in XL can be hacked...
--
HTH...

Jim Thomlinson


"Link" wrote:

Is there any other way to lock worksheet apart from tool, protect? I have a
workbook that I will be sharing, but apart from some cells I need it to be
locked. I realized that locking it through tool, protect is about 5% safe.

Jim is correct, there is no way to be 100% certain that your work cant be
hacked, stolen, etc. However, Ive found that the following combination
(both #1 & #2 together) offers pretty good protection:

#1) Tools Protection Protect Sheet (or Protect Workbook), then enter a
Password.
#2) Tools Share Workbook Allow Changes.

When you say 'sharing' I can't tell if you mean you will do a 'Share
Workbook', like I described above, or whether you will simply distribute your
workbook to other users, but if you do en up doing a 'Share Workbook', be
forewarned that several users in the file at the same time will probably
corrupt the file. It depends on the size of the file, I believe. If you
really want to share your data with other users simultaneously, and in real
time, you may be much better off using Access for your app, or you may be
much, much, much better off using Access for your app.


Good luck,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Link" wrote:

Thats good news!!! So, is there any other way to lock certain cells apart
from tool, protect? Just want to know.
"Jim Thomlinson" wrote:

If you are looking for a way of locking a workbook that can not be hacked
then you are out of luck. Everything in XL can be hacked...
--
HTH...

Jim Thomlinson


"Link" wrote:

Is there any other way to lock worksheet apart from tool, protect? I have a
workbook that I will be sharing, but apart from some cells I need it to be
locked. I realized that locking it through tool, protect is about 5% safe.

THANK YOU!

"ryguy7272" wrote:

Jim is correct, there is no way to be 100% certain that your work cant be
hacked, stolen, etc. However, Ive found that the following combination
(both #1 & #2 together) offers pretty good protection:

#1) Tools Protection Protect Sheet (or Protect Workbook), then enter a
Password.
#2) Tools Share Workbook Allow Changes.

When you say 'sharing' I can't tell if you mean you will do a 'Share
Workbook', like I described above, or whether you will simply distribute your
workbook to other users, but if you do en up doing a 'Share Workbook', be
forewarned that several users in the file at the same time will probably
corrupt the file. It depends on the size of the file, I believe. If you
really want to share your data with other users simultaneously, and in real
time, you may be much better off using Access for your app, or you may be
much, much, much better off using Access for your app.


Good luck,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Link" wrote:

Thats good news!!! So, is there any other way to lock certain cells apart
from tool, protect? Just want to know.
"Jim Thomlinson" wrote:

If you are looking for a way of locking a workbook that can not be hacked
then you are out of luck. Everything in XL can be hacked...
--
HTH...

Jim Thomlinson


"Link" wrote:

Is there any other way to lock worksheet apart from tool, protect? I have a
workbook that I will be sharing, but apart from some cells I need it to be
locked. I realized that locking it through tool, protect is about 5% safe.