Protect Workbook / Worksheets

[StudentMod]

I have an Excel workbook that runs a macro to update data on lots of different spreadsheets within the workbook from an external database (pivot tables). This workbook is in a shared area so that it can be used by many different people. My problem is that i need to protect the workbook / worksheets from modification when not being updated; but allow the macro updates to take place when the macro is running. Basically I want to stop people messing around with the workbook and its worksheets but allow the updates via an update button they use to run the update Macro. Hope this makes sense. Would appreciate any ideas and thoughts on this.

Regards

StudentMod

[se1429]

Hi,

Enter this code in the worksheet activate event.

Please Login or Register  to view this content.

This will protect the user interface only, and allow the macro to make updates.

Regards.

[StudentMod]

Thank you. Will this protect the worksheets from users who try to change cells when the macro has stopped running ?

Regards

StudentMod

[se1429]

Hi,

The protection will remain intact unless someone unprotect the sheet. All this statement is doing, is exempting the macro from the protection. You can test this for yourself.
I have written a couple of post on protection, if you are interested. Here is a link.
http://www.exceldigest.com/myblog/category/protection/

Regards.

[StudentMod]

Will give it a go. Many thanks for your help.

Best Regards

StudentMod

[john dalton]

I have a similar problem with my workbook where do I put the line of code and how?

[royUK]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.