shared document: protection issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am writing a little VBA program that should enable two users to fill in
data on a shared wkb. I am a fan of shielding the actual data on the
worksheet(s) from direct access by the users by an interface (userforms).
Thus, the worksheets are protected, and the data are submitted through a
form. The data are tranferred to the sheets after being checked and
processed. To be able to write the data, the sheets must be temporarily
unprotected, but to my horror and surprise that does not work in a shared
workbook. The 'Unprotect' method fails, it tells me. Yet the help file
(windows 2000 professional and corresponding Excel verion) tells me nothing
about that. Can this problem be avoided/solved? Thanks in advance,

Arne
 
Not sure where you are looking, but under limitations for shared workbooks it
says:

Protect or unprotect worksheets or the workbook. Existing protection remains
in effect.

That is from a list of things you can't do.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbook removes cell protection 1
Running Macros in a Shared File 2
Copying in sheet with protection with the use of a macro 5
Protection Problems 1
Protecting worksheet. 1
Macro can not unprotect a sheet in a shared workbook 4
Protect / Unprotect Sheet in Share Workbook Excel 1
Copy data using macro (with worksheet protect) 5

Back
Top