Vicki has attended:
Excel Advanced course
Protecting data
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
RE: Protecting data
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
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
