SORT DATA ON A PROTECTED WORKSHEET!

R

Romileyrunner1

Hi,
is there a way of allowing all users to sort data using a macro function
(key stroke or linked to an object) whilst having the worksheet protected to
stop formulas ect. being tampered with / ruined!

Thanks!
 
E

Eduardo

Hi,
When protecting the sheet you under where you enter the password, there is
an option that says " Allow all users of this worksheet to" there check sort

if this helps please clikc yes, thanks
 
R

Romileyrunner1

Hi, I`ve ticked that box and it doesn`t seem to allow the sort whenthe sheet
is password protected. If I protect it without a password and write the macro
which unprotects , sorts then re-protects : then that is fine. But is there a
way to do it with a password prtected sheet (without it asking for the
password again!!!)
I think I`m on Excell 2003.
Thanks
RR1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top