Lock Excel doc from macro?

[#1]

Hi All,

I have a macro that exports data to excel and emails it to a list of users. I need to lock the Excel doc to prevent users from editing data.

Any Ideas?

[calvindk]

This thread should be able to help you with the final step of your macro:

http://www.mrexcel.com/forum/excel-questions/81185-protect-unprotect-worksheet-through-visual-basic-...

[#3]

Thanks for your response Anders,

The example in that thread seems pretty complex. All I need to do is lock the entire sheet.

Any Ideas?

[calvindk]

Only take the lock part. You are not getting around using VBA from what i can tell.