Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

read only passwords

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Read only passwords

Read only passwords

ResolvedVersion 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

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.