Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent Cell modification when Excel is executed
Hi,
I have been searching around the various excel forums but cannot find a solution to the problem I have. We have a number of PC's now functioning on our factory shop floor, all of which access various excel documents that display calculations the users need to use for the manufacture of our goods. These have all been produced over time and there are 100's of them. The issue we have is not allowing the users to modify the cells. All the files are read only so they cannot alter and save anything, however there is always the chance that they may mistakenly overtype a cells value unkowingly and use that incorrect value and hense produce incorrectly which could have costly implications. Is there a solution whereby all files opened by these PC's can be automatically locked when opened so the cells cant be modified at all? We have 100's of excel spreadsheets that they will be using so opening each one and locking them that way would be a huge exercise and waste a lot of time. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent Cell modification when Excel is executed
The only solution I can think of involves some work on your part. That
would be for you to get every such file into one folder of one computer. You would then run some code (a macro) to loop through all those files and loop through all the sheets in each file and protect each sheet, with or without a password, as you choose, then save each file. The code would do all that. Then you would have to place each file back into its original computer. This would give you something to do on a weekend <g. HTH Otto "Paul Worsnop" wrote in message ... Hi, I have been searching around the various excel forums but cannot find a solution to the problem I have. We have a number of PC's now functioning on our factory shop floor, all of which access various excel documents that display calculations the users need to use for the manufacture of our goods. These have all been produced over time and there are 100's of them. The issue we have is not allowing the users to modify the cells. All the files are read only so they cannot alter and save anything, however there is always the chance that they may mistakenly overtype a cells value unkowingly and use that incorrect value and hense produce incorrectly which could have costly implications. Is there a solution whereby all files opened by these PC's can be automatically locked when opened so the cells cant be modified at all? We have 100's of excel spreadsheets that they will be using so opening each one and locking them that way would be a huge exercise and waste a lot of time. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent Cell modification when Excel is executed
Hi Paul,
If you want the user not to change information in a cell just lock it and protect the worksheet. when they try to enter enything a pop up error message will tell them that the cell is protected "Paul Worsnop" wrote: Hi, I have been searching around the various excel forums but cannot find a solution to the problem I have. We have a number of PC's now functioning on our factory shop floor, all of which access various excel documents that display calculations the users need to use for the manufacture of our goods. These have all been produced over time and there are 100's of them. The issue we have is not allowing the users to modify the cells. All the files are read only so they cannot alter and save anything, however there is always the chance that they may mistakenly overtype a cells value unkowingly and use that incorrect value and hense produce incorrectly which could have costly implications. Is there a solution whereby all files opened by these PC's can be automatically locked when opened so the cells cant be modified at all? We have 100's of excel spreadsheets that they will be using so opening each one and locking them that way would be a huge exercise and waste a lot of time. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
Excel Checkbox can be regconized in a formula and be executed | Excel Worksheet Functions | |||
When a cell is merely selected, executed an evaluation? | New Users to Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel |