Quote:
|
Originally Posted by gazzae
Neither, its in the visual basic editor.
Press Alt + F11
Select worksheet from the first drop down menu and then change from the drop down beside it. Paste the second lot of code in there.
|
That seems to do the trick nicely. Thank you very much.
But just to be awkward!!!!! I know some of the people that will be completing this sheet. Using that method, if I overwrite with the same information, the box will still change red. Is there anyway of stopping that?
Many thanks
Abs