MACROS

Hi Chris, thanks for your query. There are two things involved here. You lock a page but simply accessing the Tools - Protection options and setting the permission rights as required. However, to protect the VBA code, you need to right-click on the VBAProject heading in the Project Explorer panel of the Design Environment, select VBAProject Properties and protect the code from their. This prevents users from accessing the code but still allows the macros to run.

Hope this helps,

Anthony