Restricting number of viewings?

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

Guest

Without using macros, is there a way to allow someone to view an application only once or twice, after which point they could no longer view the spreadsheet (for example, if I want to send a worksheet sample that I don't want to be used permenantly).
 
I don't think so, you can restrict access with macros but this can be
overcome by opening the workbook with macros disabled.
You can also write code to prevent a workbook being opened unless macros are
enabled, but this is overcome quite easily by anyone with a little knowledge
of Excel and VBA.
In short, Excel is not designed for security, protection etc is really only
to prevent accidental overwriting of formulas etc and maybe rudimentary
protection aimed at the novice,
Regards,
Alan.
Ryan said:
Without using macros, is there a way to allow someone to view an
application only once or twice, after which point they could no longer view
the spreadsheet (for example, if I want to send a worksheet sample that I
don't want to be used permenantly).
 

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

Back
Top