ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I lock a boarder from being changed or removed? (https://www.excelbanter.com/excel-discussion-misc-queries/176536-how-do-i-lock-boarder-being-changed-removed.html)

Royal Jump

How do I lock a boarder from being changed or removed?
 
I am adding a boarder around some of my data and when I protect the sheet and
or workbook the boarders can still be changed. How do I lock a boarder from
being changed or removed once I protect the sheet and or workbook.

Dave Peterson

How do I lock a boarder from being changed or removed?
 
What version of excel are you using?

In xl2002+, you can protect the worksheet and still allow users to format
cells. Any chance you did this?

Royal Jump wrote:

I am adding a boarder around some of my data and when I protect the sheet and
or workbook the boarders can still be changed. How do I lock a boarder from
being changed or removed once I protect the sheet and or workbook.


--

Dave Peterson


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com