Prevent File Linking

y2k · Mar 4th, 2002, 06:19 AM

Is it possble to prevent users from creating links to a file? A small amount of users have access to one sheet in a file. The file contains 4 sheets but I have managed using hiding and a little bit of code to prevent users from ever seing the other 3 sheets without a password (which they don't know so they can't see the sheets!). However, they'll still be able to create a link to the hidden sheets once they know the sheet name (not hard to guess what it would be either). Is there anyway to prevent the them from creating the link?

Thanks

Corni · Mar 4th, 2002, 08:50 PM

In W2K you can protect a workbook both to open or/and to modify the book (File/Save As/Tools/General OPtions/Save Options). Input a PWD both to open and to modify the book. Whoever is trying to link to your book, any of the sheets, is going to be prompted for the PWD when the respective formula executes. If no PWD is provided the result in the cell will display #REF!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 06:19 AM	#1
y2k Board Regular Join Date: Feb 2002 Location: Ireland Posts: 133	Is it possble to prevent users from creating links to a file? A small amount of users have access to one sheet in a file. The file contains 4 sheets but I have managed using hiding and a little bit of code to prevent users from ever seing the other 3 sheets without a password (which they don't know so they can't see the sheets!). However, they'll still be able to create a link to the hidden sheets once they know the sheet name (not hard to guess what it would be either). Is there anyway to prevent the them from creating the link? Thanks

Mar 4th, 2002, 08:50 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	In W2K you can protect a workbook both to open or/and to modify the book (File/Save As/Tools/General OPtions/Save Options). Input a PWD both to open and to modify the book. Whoever is trying to link to your book, any of the sheets, is going to be prompted for the PWD when the respective formula executes. If no PWD is provided the result in the cell will display #REF!