View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default 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