ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i give password to open for Excel File? (https://www.excelbanter.com/excel-discussion-misc-queries/14758-how-do-i-give-password-open-excel-file.html)

SWATI GAMBHIR

how do i give password to open for Excel File?
 


Gordon

SWATI GAMBHIR wrote:
<nothing
PLEASE write your question in the BODY of the post, not the subject line.

From Excel Help: (You DID look there first, DIDN'T you?)


On the File menu, click Save As.

On the Tools menu, click General Options.

Do either or both of the following:

If you want users to enter a password before they can view the workbook,
type a password in the Password to open box, and then click OK.

If you want users to enter a password before they can save changes to
the workbook, type a password in the Password to modify box, and then
click OK.

When prompted, retype your passwords to confirm them.

Click Save.

If prompted, click Yes to replace the existing workbook.

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk


All times are GMT +1. The time now is 05:08 AM.

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