protect and unprotect in shared excel

[mark-gabb]

protect and unprotect in shared excel

ok hey guys last question for my workbook im trying to get going

i have built in a macro repair fuction, to repair dodgy formulas in our LOS AND DTD colums, with a unprotect and protect module built into it

but when i share i cant use it because of the imposibility of unprotecting a sheet while in shared mode....

all users who use the sheet have to be unable to touch these colums because of the problems they cause by fiddling with it, but i need the macro to be able to access it to fix the problems.....


some users need to be able to edit one part and other users a different part....

if there is anyway to do this it would be great someone could fill me in

i know alot of the macros are very messy if anyone knows how to clean them up that would also be awesome