Is there a way to secure a spreadsheet so the user can enter data into it,
print it, but not save it in any way?

Thanx.

Not really. You can disable menu bars and toolbars (using VBA) but a user
could always work around those using keyboard shortcuts or creating another
workbook.

Now, if you just don't want them to over-ride the current workbook, that's
possible. When you go to Save-As, under Tools-General options, choose to open
in read-only mode (and use a password).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steven Sinclair" wrote:

Is there a way to secure a spreadsheet so the user can enter data into it,
print it, but not save it in any way?

Thanx.

Okay...I know this isn't the correct forum, but can this be done in Word,
using a fillable form, or the like? Or is my solution going to be to go with
Adobe and create a fillable form there? Because I know for a fact that I can
disable ANY aspect to an Adobe file that I desire.

Thanx.


"Luke M" wrote:

Not really. You can disable menu bars and toolbars (using VBA) but a user
could always work around those using keyboard shortcuts or creating another
workbook.

Now, if you just don't want them to over-ride the current workbook, that's
possible. When you go to Save-As, under Tools-General options, choose to open
in read-only mode (and use a password).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steven Sinclair" wrote:

Is there a way to secure a spreadsheet so the user can enter data into it,
print it, but not save it in any way?

Thanx.