Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection killed by sort button
Hi, I am working in Excel 2000.
I have a spreadsheet with one worksheet protected on open with userinterfaceonly set to true to allow users to use the autofilters. Users also need to use the sort function, so I have created a button which simply calls the excel sort dialogue box. But when ok is pressed on the dialogue box the protection on the worksheet has been removed. Can anyone explain why this is happening, and suggest how to resolve the issue, as we need the protection in place to prevent accidental loss of data. Thanks Martin. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection killed by sort button
Hi TykeInBurton,
I am able to replicate your experience in xl2000. In your button code try something like: Application.Dialogs(xlDialogSort).Show ActiveSheet.Protect UserInterfaceOnly:=True, _ Password:="ABC" --- Regards, Norman "tykeinburton" wrote in message oups.com... Hi, I am working in Excel 2000. I have a spreadsheet with one worksheet protected on open with userinterfaceonly set to true to allow users to use the autofilters. Users also need to use the sort function, so I have created a button which simply calls the excel sort dialogue box. But when ok is pressed on the dialogue box the protection on the worksheet has been removed. Can anyone explain why this is happening, and suggest how to resolve the issue, as we need the protection in place to prevent accidental loss of data. Thanks Martin. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection killed by sort button
Thanks for that Norman, it works a treat
rgds Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to keep custom menu from being killed until all wkbk copys clo | Excel Discussion (Misc queries) | |||
Sort during protection | Excel Discussion (Misc queries) | |||
EXCEL.EXE is not killed | Excel Programming | |||
Excel Instance is not killed from clasic asp | Excel Programming | |||
I've killed the copy process | Excel Programming |