Lock workbook.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 26 Apr 2004 09:43 GMT

Hello everybody,

I have two workbooks, in the first I have some Forms (for me its programs
workbook) and in the second I have datas.

Is there some way how can I lock (write) the data workbook only for
Macros-Forms. I dont want still open and close this workbook

Thanks
Tom

Reply to this Message

Earl Kiosterud - 26 Apr 2004 16:44 GMT

Tom,

I think you can do that. You can protect the sheets (each) in the Data
workbook (Tools, Protection, Protect Sheet). The Programs workbook can
either unprotect the sheet before any update, then re-protect it, or can
first issue something like:

Workbooks("Data.xls").Sheets("Sheet1").Protect UserinterfaceOnly:=True

The UserInterfaceOnly allows macros to update the sheet, but not the user
directly. The protection is remembered at the next opening, but the
UserInterfaceOnly part is not. So you must issue it again in. You can do
that in the Programs workbook, so that no macros need be enabled in the data
workbook.

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Hello everybody,
>
[quoted text clipped - 6 lines]
> Thanks
> Tom

Reply to this Message

Tom - 27 Apr 2004 06:56 GMT

Thank you very much
Tom

> Tom,
>
[quoted text clipped - 20 lines]
> > Thanks
> > Tom

Reply to this Message