Software

Ask something
Discussion Locked

Excel Worksheet Protection Bug?

0 helpful
2 replies

by carlrardon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When a worksheet is protected, it is possible to change the formatting of unlocked cells by copying and pasting. This can change merge format, borders, font, etc.

Has anyone else experienced this? Is there a fix?

2 replies

by dklippert

You can prevent the user from using Copy/Paste.
with an event code.

You can ask that they use Paste Special Values.

Or you can use Excel 2002

by carlrardon

I wasn't very clear regarding the intent of my original question. I couldn't find any mention of this bug on the Microsoft Knowledge Base. I was asking if there was a patch to fix it rather than a workaround.

This discussion is closed to new replies.