ExcelBanter - Avoid Deleting a Shared Workbook using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Avoid Deleting a Shared Workbook using VBA (https://www.excelbanter.com/excel-programming/297423-avoid-deleting-shared-workbook-using-vba.html)

gr8guy

Avoid Deleting a Shared Workbook using VBA

Hi,

Anybody knows how to stop Users from deleting a Shared workbook by entering VBA code in that workbook which will prevent any user who clicks the workbook (to open it) or tries to save the opened workbook as another name?

Rgds,

Eijaz

All times are GMT +1. The time now is 12:14 PM.