XL97 - AUTO FILTER

S

Steve Jones

Hi

I have a spreadsheet created in Excel 97. I wanted to hide the formulas
although not particularly complicated, I didn't want the user to see them.

This I can do but on protecting the sheet I or the users cannot use
Autofilter. Is there any way around this?

Thanks very much
Steve
 
P

Peter Atherton

Steve

Excel is not marketed as a safe application so the answer
is no.

However, you can create names for constants such as Mark-
up = 2.37. This is done in Insert, Names Define. Where the
text box asks for a range type in =2.37 and use the
formula =ref*markup.

The user can still find out what this refers to if they
know where to look.

You can also create a custom function in VBA and use a
constant there. The VBA module can be protected but is
easily broken by hacking tools. It depends on how much
protection you think you need.

Regards
Peter
 
R

RagDyer

Deb,

Have you actually attempted, successfully, to use Autofiter on a protected
sheet that had the "Use Autofilter" box checked in the protection dialog box
?

Doesn't work in my XL02 SP-2 !
Autofilter is "grayed out".
 
Top