I created a new Style, but mistakenly I included the "Locked" property.



OK, I thought, I'll modify it.

But Excel wont let me do that because it says that the Worksheet in locked.

I've been right through the Workbook and unprotected all of the Worksheets, but I still cannot modify the Style.

Oh well, I'll delete it then and start over.

But Excel won't let me do that either, for the same reason.

How can I back out of this trap ?

If you upload a workbook containing your locked Style, someone might be able to advise on how to remedy the situation.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you, but the Workbook is packed with sensitive information :-(
Is it possible, perhaps, to delete a Style in VBA ?

So save a copy without the sensitive info and upload that.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross-posted at: https://eileenslounge.com/viewtopic.php?f=27&t=42236
For cross-posting etiquette, please read: A Message to Forum Cross Posters - Excelguru

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]