Paste link With Worksheet that has password
 

I have a document that I want to hide some of the rows from users. The
original workbook has a password so users cannot see the file. How do I
setup a pastelink with a password protected workbook or can I put a password
on original document that only allows user to see certain rows?

Paste link With Worksheet that has password
 

Brenna,

Hope this is what you were looking for, I didn't quite understand your post.

If you protect a sheet (Tools-Protection-Protect Sheet...) with a password
that has hidden rows the user will not be able to unhide the rows without
that password, but they can still open the document. The user still has the
option of entering a hidden cell reference into the 'Name Box' or using
Edit-Go To which will allow them to see the contents of the cell in the
formula bar.

The following code with stop them from using these methods. To enter the
code, right click the sheet tab and select "View Code"

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range(Target.Address).EntireRow.Hidden = True Then Target.Offset(1,
0).Select
End Sub

Mike


"Brenna" wrote:

I have a document that I want to hide some of the rows from users. The
original workbook has a password so users cannot see the file. How do I
setup a pastelink with a password protected workbook or can I put a password
on original document that only allows user to see certain rows?