Cell Protection Errors

I am having difficulty adding additional source code as when I try to paste it give the following error "cell or worksheet protected and therfore read only".

Also, cannot delete existing source that I have already entered as it gives the same error.

When I publish I also get a protection error as before and a macro error with the option to halt/step/continue/ If I continue it usually finishes and publishes OK. The file permissions on my xls file are not read only.

RE: Cell Protection Errors

All the spreadsheets within the program are sheet protected. They are protected to minimized the chance that a user will corrupt the program.

If you need to paste data directly into the program, first highlight the cell, then paste the data into the formula bar located just below Excel's menu items using the Crtl-v keyboard command.

It is not recommended to paste data directly into the cells. If you do, then you stand a chance of corrupting the program. If you do corrupt the program, then you will have to start over again with a fresh copy of the xlecom.xls file.

If you need to start with a fresh copy of the program, see the following topic for Upgrading to a New Release of XLEcom.

If you choose to paste data directly into the cells, you should always use the paste special >> values command instead of the direct paste command. This way only the data values will be pasted into the cells without any of the original formatting initially applied to the data.

Refer to the following topic for more information: Copying and Pasting Data into the User Designated Data Cells

Sam Raheb
XLEcom Program Developer