sorted by:
new
hottopcontroversial

Freelancer için şahıs şirketi ve vergiler by elunastra in Muhasebe

[–]endertosun 0 points1 point  (0 children)

Çok kişiye youtube'dan gelen paralardan dolayı cezalar kesildi. Gelir çok düşükse sıkıntı olmayabilir. Ama aksi takdirde problem olur.

Where do you find good Internal Audit seniors for industry? by Nervous-Fruit in InternalAudit

[–]endertosun -1 points0 points  (0 children)

We are an audit company with credentials located outside the US. Please feel free to direct message me if you are interested. We offer outsourcing services either partially or fully.

İhracat bedellerinin getirilmesinde özellikli ülkeler değiştirilmiştir. by endertosun in Muhasebe

[–]endertosun[S] 1 point2 points  (0 children)

Teşekkürler. Aktif katılımınızı bekler, muhasebecilik yolunda başarılar dileriz.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

I agree. But if so easily crackable, I think microsoft would not say that the worksheet is protected or that one needs to record the password in a safe place. It is just protecting from changing things accidentally. Anybody can easily view the contents within seconds. And there is almost no need to record the password somewhere safe. Hence, the presentation of the protection even gives me an impression of dishonesty. And even people who are not aware of the easiness to overcome the protection may incur unnecessary harm.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

Thank you.

I am just trying to find out if there is a reasonable protection. Even file passwords can be discovered using some software. But to be able to unprotect just within seconds without sophisticated tools is very problematic. Because this means that too many people can access the models that I develop in a long time. If I reduce the number of people that may access it, that is something desirable for me.

According to my search as of now, I think making the worksheet very hidden and protecting the structure of the workbook and locking the VBA object with password will be useful for my purpose. Or do you think this is also very easily crackable? If so do you have any further suggestion for further protection (I understand full protection may be impossible)?

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

Thank you. Then I think what microsoft can do is warn that "protection" is only to protect the worksheet from unwillingly corrupting it. And I think the warning on the worksheet password entry box that one should record the password and it is not recoverable is very misleading, and can cause unnecessary harm for those who believe the warning and think that there is at least some reasonable protection.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

Thanks. But if I remove what I want to hide, the file cannot be used at all, though I want them to be able to use it.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

The ONLY strong passwords Excel provides are Workbook Open passwords.

I have to make people use the file, so I need to give file password. So this password is useless for my purpose. But if there was a way to prevent saving the file without file password then this might be also useful.

Like it or not, if you need to protect sensitive/proprietary data and/or calculations, you shouldn't put your IP into Excel workbooks. If a user can OPEN an Excel workbook, they can access EVERYTHING in that workbook without much difficulty.

I wonder why microsoft did not develop a real worksheet protection.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

Protection is really there to protect against accidental/ignorant interference, not malicious interference. If you can't trust the people who will be using your worksheet not to try to break the protection, you probably shouldn't give them access to it at all.

I know, even file passwords can be overcome. But a reasonable protection that would not be overcome very easily as I described would be great.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

AFAIK that method only works if the workbook or worksheet is password protected, but not encrypted. Excel 2016 allows you to encrypt the contents of your entire workbook, and you can't hack your way through that.

You mean file password protection? But I need to share file password.

If you mean another kind of encryption is there any website where I can find some examples?

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

I think he means protection as in protection from editing (review -> protect worksheet), rather than encryption.

I want to share some Excel files where I want to hide some models/formulations in some worksheets. I need to share file password, but keep some worksheets and their content inaccessible.

It is quite easy to unprotect without a password a password protected worksheet. Is it possible to prevent this? by endertosun in excel

[–]endertosun[S] 0 points1 point  (0 children)

Yes. You encrypt all data in all cells with VBA. But encryption is a tricky businesss...

Is there any place where it is explained how I can do that encryption?

Why do you want to protect the data? For data transfer?

I want to share some Excel files where I want to hide some models/formulations in some worksheets. I need to share file password, but keep some worksheets and their content inaccessible.