excel vba training - Protecting workbooks

The UK's most regular instructor-led training courses.
Training information: excel vba training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Protecting workbooks

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

by - delegate Sarah [6 posts] (2007 Aug 6 Mon, 11:10) Reply

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

Thank you

Sarah

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Protecting workbooks

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 7 Tue, 05:50) Reply

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

by - delegate Sarah [6 posts] (2007 Aug 7 Tue, 11:16) Reply

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

RE: Protecting workbooks

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 7 Tue, 12:52) Reply

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

· Why Should I Learn Visual Basic in Excel?
· Improve Performance Of Your Excel Macros
· Reporting and Analysis with Excel
· Excel and Inventory Management
· Tips for Transitioning to Excel 2007

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips