Protected Forms

[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

 

[Tom Ogilvy]

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.

 

[Earl Kiosterud]

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.

 

[Tom Ogilvy]

Search the Excel groups with groups.google.com for code to unprotect a
workbook and all its sheets.

 

[portchili]

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