excel vba courses london - Protecting data

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

Resolved · Low Priority · Version Standard

Protecting data

Vicki has attended:
Excel Advanced course

by - delegate Vicki [12 posts] (2007 Mar 20 Tue, 15:39) Reply

In the older version of excel you could protect parts of or all of a spreadsheet. I may be being dozy but I can't seem to find how to do this on the new version.
I have created linked sheets (timesheets actually) which works by - weekly sheets link to a period sheet and that in turn is linked into a valuation sheet. I need to protect the sheets leaving only the cells (which could be columns or rows or groups of cells) that others can input to - thereby protecting my calculations.

Please help

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Protecting data

by - delegate Vicki [12 posts] (2007 Mar 21 Wed, 11:51) Reply

It's Ok I worked it out and it is extremely long-winded process in relation to the previous version. I also worked out that as I had a lot of these to change (5 sheets per period X 13 periods + 1 valuation sheet) I recorded a macro to reduce the effort!

RE: Protecting data

by - trainer Rich platinum contributer [713 posts] (2007 Apr 5 Thu, 13:14) Reply

Hi Vicki,

Sorry it has taken a while to look at your question. We have been swamped lately!

I'm glad you solved your issue. Thanks for posting your solution. This will help your fellow delegates too!

Have a great Easter.

Regards, Rich

· How to Create Better Excel Spreadsheets: Part Two
· Advanced level training: Microsoft Excel and the Web
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Training - Numerical excellence for all

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

excel vba courses london - Protecting data

Related articles

Excel tip:

Freeze Rows and Columns to keep lables displayed