Is it possible to sort data within a password protected worksheet

R

Romileyrunner1

Hi,
I`m using excell 2003??
I can sort data using a macro which unlocks the protection then reasigns it
back afterwards. But is there a way to do this whilst under a password
protected sheet. Have tried having a macro that first types in the password
to unlock, sorts the data then retypes the password .... BUT, running the
macro when the sheet is locked requests the password to be entered straight
away and so defeats the object in the password being there at all.
Any ideas?
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

Similar Threads

SORT DATA ON A PROTECTED WORKSHEET! 2
Password prompting to unhide worksheet allows temporary visibility 2
allow a user to edit ranges in a protected worksheet 3
Is it possible to copywrite a workbook? Or other protection option 6
How to bypass password when pasting FROM a protected workbook 3
Modifying a locked/protected sheet 3
How do you insert & delete rows in a protected worksheet? 1
How can I import a picture on a protected worksheet 0

Top