Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort protected sheet
I have a sheet which has pasted links from another sheet but
consolidates the information, I can sort this information if the sheet is unprotected, but not if it is protected. I really need to protect the sheet to stop inadvertently overwriting the pasted link. I think I can do this by having the Macro unprotect, do the sort and then reprotect. Is there a way of doing this easier? and is there a way of stoping anyone of reading a macro which at times is as important as protecting the data it points to. Thanks EPJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow sort of Protected Sheet | Excel Discussion (Misc queries) | |||
How to - sort a protected sheet? | Excel Worksheet Functions | |||
Sort Protected Sheet | Excel Discussion (Misc queries) | |||
can i sort a protected sheet | Excel Discussion (Misc queries) | |||
Sort on a protected sheet | Excel Worksheet Functions |