View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How do I lock VBA?

You are probably best off to just protect the project. In the VBE in the
Project Explorer - right Click on the Project - Select Properties - Select
Protection - Check Lock Project for Viewing and add a Password.
--
HTH...

Jim Thomlinson


" wrote:

After wb and sheets are protect Alt-F11 will still open my VBA window.
Is there a way to stop this from happening?

tia

jp