Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
Some of my sheets have been marked as "xlVeryHidden".
These sheets contain data that I do not want users to be able to modify. If a user knows the codename or tab name of any of these hidden sheets, could they actually be able to modify data on that sheet in any way?? Can they enter a formula onto a visible sheet that references a hidden sheet to change the data?? thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
Formulas on a visible sheet cannot alter anything on another sheet or
anywhere for that matter. Formulas return values to the cell in which they are written. Back to first question............... Yes, through VBA a user could alter values on a hidden sheet if they knew the tab name or codename of that sheet. Or they could run VBA to unhide the sheet and change everything on it. Or even delete it. Gord Dibben MS Excel MVP On Fri, 12 Feb 2010 15:21:31 -0700, "Robert Crandal" wrote: Some of my sheets have been marked as "xlVeryHidden". These sheets contain data that I do not want users to be able to modify. If a user knows the codename or tab name of any of these hidden sheets, could they actually be able to modify data on that sheet in any way?? Can they enter a formula onto a visible sheet that references a hidden sheet to change the data?? thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
What if my VBA project is password protected so they cannot
access any of the code modules??? Will that help?? What are a few ways I can prevent anyone from modifying data on a hidden sheet??? I need to cover my bases as much as possible. thank u "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Yes, through VBA a user could alter values on a hidden sheet if they knew the tab name or codename of that sheet. Or they could run VBA to unhide the sheet and change everything on it. Or even delete it. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
See in-line
On Fri, 12 Feb 2010 16:02:26 -0700, "Robert Crandal" wrote: What if my VBA project is password protected so they cannot access any of the code modules??? Will that help?? Not much. I'll just run code from another workbook to access your hidden sheets if I know the names. What are a few ways I can prevent anyone from modifying data on a hidden sheet??? I need to cover my bases as much as possible. Since you're dealing with Excel's relatively weak internal security you would be hard-pressed to cover all bases. How sophisticated are your snoopy users and how much time and effort are they willing to expend? If the hidden worksheets were protected.....all cells locked and unprotect password set, users would have to know password to alter cells even if they could unhide the sheets. But easy enough to crack sheet passwords. If the workbook structure was protected with a password, hidden sheets could not be unhidden through code. But easy enough to crack workbook protection passwords. I am assuming the hidden sheets' cells are referenced by the visible sheets so simply removing those sheets is not an option. Gord thank u "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Yes, through VBA a user could alter values on a hidden sheet if they knew the tab name or codename of that sheet. Or they could run VBA to unhide the sheet and change everything on it. Or even delete it. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
Lock all the cells on the worksheet and protect the worksheet. But even that
won't stop people who are really interested. The hidden-ness of the worksheet doesn't really offer any more protection--except that it's out of sight, so it may be out of mind. Robert Crandal wrote: What if my VBA project is password protected so they cannot access any of the code modules??? Will that help?? What are a few ways I can prevent anyone from modifying data on a hidden sheet??? I need to cover my bases as much as possible. thank u "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Yes, through VBA a user could alter values on a hidden sheet if they knew the tab name or codename of that sheet. Or they could run VBA to unhide the sheet and change everything on it. Or even delete it. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify data on a hidden sheet?
Locking the VBProject won't help. The user could simply run
Sub AAA() Dim WS As Worksheet For Each WS In Workbooks("YourWorkbook.xls").Worksheets Debug.Print WS.Name Next WS End Sub to list all the sheets, regardless of whether they are visible, hidden, or very hidden. You can protect the structure of the workbook, but there are plenty of ways to get around that. The bottom line is that Excel security sucks. It is good enough to prevent the honest user from making an honest mistake, but it isn't good enough for anything more than that. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Fri, 12 Feb 2010 16:02:26 -0700, "Robert Crandal" wrote: What if my VBA project is password protected so they cannot access any of the code modules??? Will that help?? What are a few ways I can prevent anyone from modifying data on a hidden sheet??? I need to cover my bases as much as possible. thank u "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Yes, through VBA a user could alter values on a hidden sheet if they knew the tab name or codename of that sheet. Or they could run VBA to unhide the sheet and change everything on it. Or even delete it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy hidden sheet data | Excel Discussion (Misc queries) | |||
reading data from hidden sheet | Excel Discussion (Misc queries) | |||
How can I copy the data of sheet 1 to sheet 2 with modify? | Excel Programming | |||
Close Hidden Data Sheet | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |