Protection and Formats

W

wgaskill

I've got some worksheets that are protected and I have some of the cells
formatted (borders, colors, etc.). In Excel, when you Clear->Formats in a
range of cells, the cells go back to Protection="Locked". Is this a Microsoft
standard, or can it be set to not Lock cells that were previously Unlocked?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Address Format changed after Migration 0
Returned position address on protected sheet 7
Paste Value 1
Override protected sheet message? 4
Command button wz 2 function 1
Select statement or me? 13
Excel does not accept text format! 0

Top