Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a alternating password
i got a workbook thats used on 5 machines on diffrent locations. the ppl
using it are not all that computer litterate... at the moment i tell them to "alt" "t" "t" "p" to unlock the page if they need to manualy change anything in a locked cell. problem are they now erase my formulas.. ive allready unlock the cells that they supposed to type in. in effect its a inventory workbook. they need to enter closing stocks and stocks sold. but now they mess up and dont check before they close and clear. close and clear carries the closing over and use it as the new opening. are there any how that i can have them to call me for a password? if they for example click on a button it will give them a "screen" with a word wich they then read to me. i then know what 5 digits to give to them to type in that "screen". this will then unlock the worksheet for either a set time or till they close the workbook. i cant just write the code for an event and not have any formulas on the spreadsheet itself coz im not always at a computer. im traveling a lot and thus taking them through the problem telephonicly. next time they open it they cant edit a locked cell with out calling me so basicaly i need a macro that will unlock the page but only after a "password" has been enterd thanx guys |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a alternating password
I would suggest that your life would become much easier if you set up the
worksheet so's they don't have to field phone calls to unlock sheets for them to edit locked cells. All they have to do is pound data into the unlocked cells and formulas and VBA beforeclose or beforesave code takes care of the rest. Don't let them close or save the workbook until all data entry has beeen done correctly. Gord Dibben MS Excel MVP On Mon, 17 Dec 2007 12:51:17 -0800, pswanie wrote: i got a workbook thats used on 5 machines on diffrent locations. the ppl using it are not all that computer litterate... at the moment i tell them to "alt" "t" "t" "p" to unlock the page if they need to manualy change anything in a locked cell. problem are they now erase my formulas.. ive allready unlock the cells that they supposed to type in. in effect its a inventory workbook. they need to enter closing stocks and stocks sold. but now they mess up and dont check before they close and clear. close and clear carries the closing over and use it as the new opening. are there any how that i can have them to call me for a password? if they for example click on a button it will give them a "screen" with a word wich they then read to me. i then know what 5 digits to give to them to type in that "screen". this will then unlock the worksheet for either a set time or till they close the workbook. i cant just write the code for an event and not have any formulas on the spreadsheet itself coz im not always at a computer. im traveling a lot and thus taking them through the problem telephonicly. next time they open it they cant edit a locked cell with out calling me so basicaly i need a macro that will unlock the page but only after a "password" has been enterd thanx guys |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating format | Excel Discussion (Misc queries) | |||
Alternating between worksheets | Excel Discussion (Misc queries) | |||
alternating format | Excel Programming | |||
alternating colors | Excel Worksheet Functions | |||
Alternating Margins | Excel Discussion (Misc queries) |