Shared Workbook - Defining Access Rights

G

gizmo

Hi guys,

I plan to put in place a shared workbook on the server and ideally I would
like to let excel somehow know that a particular user can only access
certains worksheets and modify even more restreined number of them.

Schematically:
All worksheets > Worksheets that can be accessed by USER1 > Worksheets that
can be modified by USER1

Would be also great if it would work for many different users (every of them
having different access rights)...

Is that possible?
Thanks for any hints!
Gizmo

BTW: What are the possible problems with "shared workbooks"? Should I be
aware of something?
 

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

Shared Workbooks & Code 1
Formula, Macro, or VBA code to find and insert 3
Sumif apllying to all sheets in workbook 2
How can a workbook grant access to another one 0
User-Level Sharing 7
Cannot save shared workbook 0
Errors with 5-10 users in Shared Workbook 1
AutoFilter settings in shared workbook 1

Top