Protection & standalone

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hi,

I have a couple of questions which are way beyond my basic
knowledge.... :confused:

What is the best way to protect a worksheet for distribution? Serial
no. per user?

Is it possible to export a spreadsheet as a standalone application?

Thanks in advance, Cam. :)
 
Good morning Cam

(1) It all depends on what you mean by protection. No form of Exce
protection cannot be cracked - it depends on what you're trying t
prtect and from whom. Be a bit more specific if you need more help o
this issue.

(2) No. An Excel file can only be read by Excel. If the person a
the other end doesn't have Excel, they can use Excel Reader (free fro
Microsoft) but all they can do is look at the spreadsheet - you'
probably be better off sending it as .pdf if no changes are required.

HTH

Dominic
 
Hi Dominic,

Thanks for your reply, I didn't know about excel viewer - I will have a
look. My spreadsheet has one value to enter so I guess it will not work
in this case but I can think of a few other instances where it would be
great.

On protection - it would be to ensure that information that I released
in an Excel file was really only accessible by the person I sent it to.
So, if they then forwarded it on to 'Anne Other'.... she would not have
access.... hope that makes sense?

Cheers,

Cam. :)
 
Excel's protection isn't made for security. I think most just consider it a way
to stop users from making bad mistakes (overwriting formulas or deleting sheets
that they shouldn't).

If a user can open your workbook, then everything is available to that user.

In fact, if you give the workbook a nice password to open, there are sites that
can break that protection, too.
 
Back
Top