Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I was wondering if there is a way to protect a sheet, but be able to sort
the data? Does anyone know a way around this. Any help is appreciated.
 
Hi mac

To use code...
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True,
AllowSorting:=True

To protect manually...
"Tools>Protection>Protect Sheet" and select "Sort"and any other options you
want from the dialog box..

But what version of XL are you using?
--

XL2003
Regards

William
(e-mail address removed)
 
Hi William,
I tried to manually protect and it does not seem to work. I am not sure how
to write the code. I am using excel 2003
 
You must log in or register to reply here.

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

Excel Protection 2
Excel Move or Copy Stopped Working? 0
Is autofilter & sort disabled in protected cells? 1
vba solution for protection 3
Editorial Why is data protection important? 0
hide columns on a protected sheet 2
Sorting a protected set of cells 3
How do you insert & delete rows in a protected worksheet? 1

Back
Top