Hi!
Is there a way to disable the ability to reference across worksheets? So that certain worksheets can only fill in text and numbers and not reference calls sucha as +sheet1!A1
regards,
Kbka
Hi!
Is there a way to disable the ability to reference across worksheets? So that certain worksheets can only fill in text and numbers and not reference calls sucha as +sheet1!A1
regards,
Kbka
Hi try this code in module of worksheet
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
That's a neet little trick. I just realized, however, that what I need is the opposite. I.e. I need to ensure that no sheet can reference a certain sheet.
The thing is that sheet1 is confidential and hidden with a password protection. However, one can still see the contents of the sheet by using references.
regards
If the sheet is called "Secret" then maybe:
Please Login or Register to view this content.
So, if someone types in a reference to the secret sheet it will be cleared.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
kbka,
Unfortunately, Excel is not a secure program. Even with code to remove references to Sheet1, the user would simply need to disable macros and then they could reference sheet1 again. Also, the user could reference that workbook, sheet1 from a completely different workbook altogether (it could be a brand new one they open on their own that has default settings, instead of using one with code and/or modified settings). So there really isn't a way to prevent a determined user from referencing a sheet to find out what is in it.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I have to agree with TA. Even if you use the code above and other code to hide sheets and thus force people to enable macros, it is always possible to work around it.
If the "secret" information were in a separate workbook, which was password protected and accessed via the original workbook, and thus the individual(s) doesn't know the password, you might be able to limit access.
It's a case of putting up sufficient barriers that it stops all but the most skilled and determined user.
Regards, TMS
Thank you.
I'll take the security into consideration
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks