Discussion Locked

Access Right for Sharing Workbook

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Have anyone know how to block a few of columns to allow a certain user to edit and certain user to view only in Excel 97/2000?

Please advise.

TQ.

1 reply

by deadly ernest

Go to 'Tools' >> 'Protection' >> 'Protect Sheet'

and then enter a password, people can view but you need the password to make changes.

I believe that if you select only the 'Objects' button you can have it apply to only part of the sheet, but best apply to the whole sheet.

If you want to stop some people from viewing part of it then it is best to have two sheets in the workbook with the concealled stuff on the 2nd sheet and not displayable with out a password, then just have links fromthe front sheet. Or you can design macros etc to show limited amounts of data.

This discussion is closed to new replies.