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

excel vba training - protecting workbooks

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Protecting workbooks

excel vba training - Protecting workbooks

ResolvedVersion Standard

Sarah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course

Protecting workbooks

How do I protect the workbook so that only I can make changes?

Thank you

Sarah

RE: Protecting workbooks

Hi Sarah, I would suggest when you are happy with the document you make it read only so the orginal is always kept safe. You can do this by File, Properties, General Tab, Read only

Hope that helps

Tracy

RE: Protecting workbooks

Thanks Tracy - but the attributes are greyed out so I cannot select the read only. Why would this be???

RE: Protecting workbooks

Hiya Sarah,

Have you tried closing the file and applying the read-only on the icon. So you are in the folder containing the file and you can right-click on the file and go down to properties and see if the box is available from there. Failing that you may find you have network issues whereby you are not allowed to create read only files. If it is your home computer or your laptop you should find this is available. Let me know

Tracy

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

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.1 secs.