Disabling Save prompt on exiting a workbook

[davidrusbridge]

Hi,

I am hoping that someone can help with some code. I have a workbook which is used by multiple users on a number of terminals. A master copy exists in a common folder with shortcuts pointing to it. I have set the workbook properties as read only.

Whenever the workbook is closed it prompts if you wish to save it which is the issue. I want to run the workbook so that when it is closed it will not prompt for Save/Save As. It just needs to close.

Any ideas will be most welcome

 

[sykes]

You could use VBA for this - in the workbook's "ThisWorkbook" module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

NB it needs to be in the _before close event of the "ThisWorkbook" module. Also, don't forget to save the workbook after putting in the code.
If you don't know how to do this, just post back and I'll give you easy instructions.

 

[davidrusbridge]

sykes,

Thank you for the quick response and the excellent solution. It works as advertised!

I would also like to find a way of allowing the macros in the workbook to run without the security prompt on opening the workbook. I know it is possible to change the default security settings generically in Excel but I would not want to do that. I just want this one workbook to open an run without the prompt.

Any help gratefully received

 

[brettdj]

Use a certificate

See http://www.mrexcel.com/forum/showthread.php?t=82819

Cheers
Dave

 

[sykes]

Pleasure, and thanks for the feedback.

 

[davidrusbridge]

Hi Brettdj,

Another excellent response. All working fine, thank you