Protect / Unprotect Sheet in Share Workbook Excel

S

soletyvenky

I am using Office 2007.

I had done a VB project in Ms-Excel. I done all my coding using the normal
Protect Sheet option.

In between the program the code will Unprotect and protect the sheet.

Now this sheet has to be saved in Shared Workbook. So, that all the users
can update online at a time and put it on shared folder.

When i saved it. The unprotect and protect commands / code are not working
in Share Workbook.

Please solve the problem.

Regards,

Venkatesh Solety
 
A

a.muppet.man

Take a look at :

Features that are unavailable In Shared Workbooks

In the Excel Help.

Unprotecting a sheet can not be achieved in a shared workbook.
 

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

Protection Problems 1
Unprotect Workbook with Function 3
Protecting worksheet. 1
Protect Workbook and Share it. 0
Simple workbook Protect 2
Protect / unprotect a form 1
Shared Workbooks & Code 1
Macro can not unprotect a sheet in a shared workbook 4

Top