Forum home » Delegate support and help forum » Microsoft Excel Training and help » Read only passwords
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Read only passwords
Resolved · Low Priority · Version Standard
Reply Tue 19 Feb 2008, 15:36Delegate Kevin said...
Kevin has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Read only passwords
How do I use a password I have captured via an input box to make a workbook read only?
For upcoming training course dates see: Pricing & availability
RE: Read only passwords
Hi Kevin,
Not quite sure what you mean here. If you're talking about password protecting a workbook, you can do this by going to File -> Save As -> Tools -> General Options -> and change 'Password to modify' field. I doubt you could use a string of characters you have captured elsewhere, unless you simply paste in the password using Control+V (on Windows).
To just make a workbook read only: right click the file in windows explorer -> Properies -> Tick 'read only' box -> Press OK.
I hope this helps. Please do reply back if you require further information. Otherwise, please mark the question as resolved.
Kind regards,
Rich
|