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

How can I sort a protected page
 

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 wrote in message
...
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