Locking Format for Certain Cells

mizeu

New Member
Joined
Jul 1, 2016
Messages
2
I have a spreadsheet that I pass around for others to fill out but they keep changing the format of certain cells from General to Text and it messes up some of my formulas. Is there anyway to lock these cells so that they stay General format and cannot be changed?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hello
As I know you have to do it mannualy, or if the cells ara always the same you can make a VBA code that retrive always the same format
Bye
 
Upvote 0
Hello
As I know you have to do it mannualy, or if the cells ara always the same you can make a VBA code that retrive always the same format
Bye
That's a nice idea, I hadn't thought of that. So am I right to assume that it is the only way around the issue and you can't lock cell formats?
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top