ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to totally protect data excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/135948-how-totally-protect-data-excel-2003-a.html)

gibsol

how to totally protect data excel 2003
 
I have a sheet of data where I have locked the cells through sheet
protection, then hidden the sheet, what I am trying to achieve is this data
to not be visible by any person other than myself.
I want this data to be totally hidden from view, i.e. not accessible by
entering a formula to pick up the relevant cell info and paste to another
worksheet.
Sheet 3 data not to be shown via formula on Sheet 5

Anne Troy[_2_]

how to totally protect data excel 2003
 
Read and heed:
http://www.officearticles.com/misc/a...t_off ice.htm

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"gibsol" wrote in message
...
I have a sheet of data where I have locked the cells through sheet
protection, then hidden the sheet, what I am trying to achieve is this
data
to not be visible by any person other than myself.
I want this data to be totally hidden from view, i.e. not accessible by
entering a formula to pick up the relevant cell info and paste to another
worksheet.
Sheet 3 data not to be shown via formula on Sheet 5





All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com