ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disable Labels (https://www.excelbanter.com/excel-discussion-misc-queries/72299-disable-labels.html)

Buthy

Disable Labels
 
Is is possible to disable one of lables on worksheet. What i mean is to not
allow user to change headings?

My Regards,
Buthy

Dave Peterson

Disable Labels
 
You can lock cells (format|cells|protection tab)
(and leave other cells unlocked--that the user can change)

Then you can protect the worksheet (tools|protection|protect sheet)

But be aware that there are lots of things that can't be done on a protected
sheet--and that sheet protection is easily broken.

Buthy wrote:

Is is possible to disable one of lables on worksheet. What i mean is to not
allow user to change headings?

My Regards,
Buthy


--

Dave Peterson


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

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