• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel protection for users

D

Deepa

New Member
Hello,


My requirement is to give edit permission for individual user to particular excel sheet. All other user can only view the sheet and all the sheets contains grouping. Kindly help in resolving this.


Thanks in advance


Regards,

Deepa
 
In 2003, Under Data - Protection, you can setup ranges which groups or individuals can edit. In 2007, it's just under the Data tab. Note that this method does require that you protect the worksheet.
 
In my requirement the following functionalities

1. Each sheet has grouping option(we will be grouping some particular rows in each sheet)

2. Particular user can edit only one sheet. They can view all the sheet(they can group/ungroup the rows and view)


im not able to ungroup and view the rows of the sheet which i have only read access since the sheet is protected. kindly help
 
I don't think you can keep the grouping AND protect your data. You could potentially use a VB Change event macro to detect changes on the other sheets and then reverse them, but that could get quite complicated.
 
You must log in or register to reply here.
Back
Top