PLEASE HELP
I am having problems with excel and any help would be greataly appreciated, I have setup a spreadsheet and I have had to draw lines in the spreadsheet to achieve the desired results. I have also set up buttons to paste in diagrams that are required at various times. My problem is that I want to lock the lines that I have drawn into place but still be able to paste in the diagrams using the macro buttons. I have found that if I lock the lines I have to protect the sheet (which I want to protect other cells from alteration). When the sheet is protected I can no longer paste in the diagrams I am using excel 98
Please help
Thanks
This message was edited by neills on 2002-05-08 03:36
I am having problems with excel and any help would be greataly appreciated, I have setup a spreadsheet and I have had to draw lines in the spreadsheet to achieve the desired results. I have also set up buttons to paste in diagrams that are required at various times. My problem is that I want to lock the lines that I have drawn into place but still be able to paste in the diagrams using the macro buttons. I have found that if I lock the lines I have to protect the sheet (which I want to protect other cells from alteration). When the sheet is protected I can no longer paste in the diagrams I am using excel 98
Please help
Thanks
This message was edited by neills on 2002-05-08 03:36