Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Copy and paste link in worksheet is extremely slow. What to doÉ | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |