Thread
:
How can I sort a protected page
View Single Post
#
2
Posted to microsoft.public.excel.programming
Jean-Yves[_2_]
external usenet poster
Posts: 253
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
Reply With Quote
Jean-Yves[_2_]
View Public Profile
Find all posts by Jean-Yves[_2_]