Protected Forms

  • Thread starter Thread starter portchili
  • Start date Start date
P

portchili

Made a form and posted it in a shared folder for co-workers to fill out
and EMail to me. How do I keep them from saving it? Thanks for any
help.

Steve
 
Please define form. Did you set up a worksheet to look like a paper form?

If it is a workbook, did you make it read only using its file attributes?

Have any control on the file permissions in the shared folder? If not,
perhaps see you lan administrator.
 
Steve,

You can prevent saving with:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

Unfortunately, macros must be enabled, and users can get around that.

Users can use File - Sent to - Mail recipient for emailing it without
saving, either as attachment, or directly into an email (mail recipient).

None of this is robust for your requirements, but perhaps it'll be useful.
 
Unfortunately, macros must be enabled, and users can get around that.

How 'bout protecting the workbook and including an Auto_Open macro that
unprotects it? That way if the user doesn't enable macros, they can't do
anything with the workbook.
 
Search the Excel groups with groups.google.com for code to unprotect a
workbook and all its sheets.
 
Tom,

Thanks for your help. It is a workbook template in Excel XP. When
someone fills in the blank, I have created a control button that emails
me. After they are done with that and close the worksheet, Excel asks
if they want to save it as a worksheet. This is what I'm trying to
prevent.

Thanks again
 
You could put code in the BeforeClose event that prevents it being saved and
avoid the prompt. You could put code in the code that mails the workbook
that closes it without saving changes.

If you want to suppress most prompts set

Application.Displayalerts = False
 
Back
Top