I created a workbook that has roughly 14 spreadsheets in it. On each
worksheet, I protected various cells and left some cells open so that users
can change those values. The problem is that this is to be used by several
users to make changes. Now that I have various cells protected, the option
to "share" the workbook is unavailable. I want multiple users to be able to
go in and enter their budgets without having to wait until someone else is
finished, but also have my formulas protected. What do I do?

I do have macros set up in this workbook which I am not sure if it will
create a problem.

thanks in advance

"michelle" wrote:

I created a workbook that has roughly 14 spreadsheets in it. On each
worksheet, I protected various cells and left some cells open so that users
can change those values. The problem is that this is to be used by several
users to make changes. Now that I have various cells protected, the option
to "share" the workbook is unavailable. I want multiple users to be able to
go in and enter their budgets without having to wait until someone else is
finished, but also have my formulas protected. What do I do?

Just having macros won't cause any trouble--but you could have trouble depending
on what those macros do.

And you can't change worksheet protection in a shared workbook.

But you can unshare the workbook, change the protection for all the sheets you
want and then share the workbook again.



michelle wrote:

I created a workbook that has roughly 14 spreadsheets in it. On each
worksheet, I protected various cells and left some cells open so that users
can change those values. The problem is that this is to be used by several
users to make changes. Now that I have various cells protected, the option
to "share" the workbook is unavailable. I want multiple users to be able to
go in and enter their budgets without having to wait until someone else is
finished, but also have my formulas protected. What do I do?

--

Dave Peterson