Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I hide certain information within a workbook?
excel 2003.
I was wondering if I could have another chart within the workbook that I can only see. Therefore, when information is entered into the visible chart, I can check if any changes have been made versus my hidden chart. |
#2
|
|||
|
|||
Excel doesn't really have this kind of protection. If you share the workbook
with anyone, then they (if determined enough) can see all your data and charts. mikie wrote: excel 2003. I was wondering if I could have another chart within the workbook that I can only see. Therefore, when information is entered into the visible chart, I can check if any changes have been made versus my hidden chart. -- Dave Peterson |
#3
|
|||
|
|||
You can make the Chart Sheet or Sheet Object on which that chart is embedded
xlVeryHidden from VBE, then password protect your VBA Project. http://HelpExcel.com "mikie" wrote: excel 2003. I was wondering if I could have another chart within the workbook that I can only see. Therefore, when information is entered into the visible chart, I can check if any changes have been made versus my hidden chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
I cant hide a workbook | Excel Worksheet Functions |