Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock VBA?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock VBA?
Why should Excel do this? If you have a second, not protected workbook open,
would you still want Excel to block access to the VBA editor? Makes no sense to me. If you want to prevent your users from viewing your code, password protect your VBA code. If you want to prevent the use of Alt-F11, you can use an OnKey method (e.g. in your Auto_open macro) to reassign this key combination to something else (or nothing at all). But be aware that user can still access the VBA editor via the menu. Cheers, Joerg wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock VBA?
Thx guys!
On Thu, 31 Aug 2006 17:03:52 -0400, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock all cells? | Excel Discussion (Misc queries) | |||
How can I lock worksheets while macros can still enter into them? | Excel Discussion (Misc queries) | |||
How to lock a file (wholly or partly) | Excel Discussion (Misc queries) | |||
Lock Project | Excel Discussion (Misc queries) | |||
Lock the Keyboard | Excel Discussion (Misc queries) |