98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Read only passwords
Read only passwords
Resolved · Low Priority · Version Standard
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?
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
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. |
Excel tip:Finding your worksheets quicklyThe arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook. |