A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to lock a file (wholly or partly)



 
 
Thread Tools Display Modes
  #1  
Old November 27th, 2005, 08:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default How to lock a file (wholly or partly)

How to lock a file (wholly or partly)

Hi.
1)
I would like to lock my file.
Thus if someone opens my file, it needs password to access it.
Do you know how I can do this?

2)
This is a bit tricky.
This time I just wish to lock part of my file (eg some worksheets, some
columns/rows, some cells)
Before someone read the data in that part of my file, it needs password before
the data will show up. Otherwise they appear hidden (unreadable).
Do you know how I can do this?

Thank you


--
Additional information:
- I'm using Office XP
- I'm using Windows XP


  #2  
Old November 27th, 2005, 09:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default How to lock a file (wholly or partly)

See these EXCEL lent pages,

http://j-walk.com/ss/excel/faqs/protectionFAQ.htm

John


0-0 Wai Wai ^-^ wrote:
How to lock a file (wholly or partly)

Hi.
1)
I would like to lock my file.
Thus if someone opens my file, it needs password to access it.
Do you know how I can do this?

2)
This is a bit tricky.
This time I just wish to lock part of my file (eg some worksheets, some
columns/rows, some cells)
Before someone read the data in that part of my file, it needs password before
the data will show up. Otherwise they appear hidden (unreadable).
Do you know how I can do this?

Thank you


--
Additional information:
- I'm using Office XP
- I'm using Windows XP


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-User vs Client/Server GeorgieGirl General Discussion 3 June 8th, 2005 11:42 PM
How to create relative and shorthand file path names 2dogs General Discussion 4 May 14th, 2005 08:49 PM
Mystery file lock Jay New Users 4 April 11th, 2005 07:49 PM
Access Lock File John Bigness General Discussion 5 March 19th, 2005 04:13 PM
Continual Error 1321 Trying to Install Office 2003 Chad Harris General Discussions 9 June 11th, 2004 08:19 AM


All times are GMT +1. The time now is 05:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.