How can I sort a protected page

I have a aggregate scoring page that has programming for calculations embeded
within
As i do not want the programming to be altered in any way i have protected
the page but this stops the users from sorting the page after they have
entered all the scores
How can i overcome this

Hi,

You can add a custom button with a sorting macro attached to it.
On workbook_open event, I use :
Sheet1.Protect Password:=PW, userinterfaceonly:=True
"userinterfaceonly" means that a macro CAN modified a protected worksheet,
so the sorting macro will work.
Regards
JY

"AK 47" <AK 47@discussions.microsoft.com> wrote in message
news:E716D2C6-F8BB-4BF2-BB73-08A1C0023E79@microsoft.com...
> I have a aggregate scoring page that has programming for calculations
embeded
> within
> As i do not want the programming to be altered in any way i have protected
> the page but this stops the users from sorting the page after they have
> entered all the scores
> How can i overcome this