chrstdvd


Hello,

Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten

Thanks Chrstdvd




Re: Protecting formulas in cells

Andy Pope


Hi,

Not that I know of without protecting the sheet.

What does 'coding formulas' actually mean






Re: Protecting formulas in cells

chrstdvd

Well Andy,

I mean that I have a macro that has code like this Range("H22") = "=Sum("A5:A16")".

I had the idea to just make a macro that repopulates the cells with the formulas prior to the Save command. That would at least have the formulas ready for the next days work.

I will not go into why or how the store managers erase them. Most of the time all I hear is: "The computer just did it".

thanks Chrstdvd






Re: Protecting formulas in cells

Andy Pope

Is there a particular reason why you can not protect the sheet





Re: Protecting formulas in cells

chrstdvd

Andy,

All my sheets with formulas are protected. I do not password protect them because I would always have to drive xteen zillion miles to fix mistakes. Like "I forgot to post a price change before I posted end of day fuel running totals".

Even though I can put a message box up that asks "Are You Sure There Were No Fuel Price Changes Yesterday." Hardly anyone looks at the screen, they just punch in numbers. Even ME, when I am in a hurry, and I close a file by hitting the RED X, hit NO and loose data on the sheets I want to save.

So anyone, who knows enough, can just unportect the sheet and do what they want. In other words, make the over short line say what ever they want it to say.

I do not know what to tell you. I erased three pages of details. You want details give me your email address and I will send you a copy of the "system" with several days worth of data for you to input, instructions and discriptions.

I am not a programmer. I took basic, fortran and cobal in colledge back 78, did some one and zero's for Navy UCK 20 computers and learned how to wirte macros in 123 on my own. Excel is just a knock off of 123, so when I got tired of ten keying and pencils, I invented the system. It works well for poeple who could do it all by hand, but the new managers, ....

thanks chrstdvd





Re: Protecting formulas in cells

js06

I have worked on creating sheets that can only be edited by a form and the steps that are done by anyone have to follow a certain order and will only allow them to edit what is necessary. The sheets can be unprotected only when they are being edited by the form preventing "accidental" deleting.

I can help put you in the right direction if you give me some more info.






Re: Protecting formulas in cells

js06

Chrstdvd, this may be of interest to you.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1279113&SiteID=1

Check this out, you would be able to create your spreadsheet and use it with VB Express and the only way someone could erase your formulas would be if they were hackers. It would even prevent you from erasing what you don't want on accident.