I am updating some paperwork at work. We do a LOT of paperwork and much is still done with a good old pen and paper. However, i am sorting things out so it much easier to avoid mistakes in calculations by forc...er...encouraging my team to use the PC's more. Trouble is, some people are not so PC minded in my work and can make a real mess of things.
Right, i have an account sheet in excel. All the layout and forumlas are sorted. To help people to not change any forumlas, edit the layout or type in the wrong cells, i have 'protected' the workbook and have locked all cells on the page, apart from the ones i want them to type thier figures into.
Now what i really want to do it highlight all the cell's they are ment to type stuff into (i.e. in yellow or something) but i don't want the highlighting to show up on the final print out.
I have looked everywhere but can find an option. Any idea's?


LinkBack URL
About LinkBacks
. Trouble is, some people are not so PC minded in my work and can make a real mess of things.
Reply With Quote