VB and VBA Users Source Code: Prevent Alt + F11 opening VB IDE in Excel
[
Home
|
Contents
|
Search
|
Reply
| Previous | Next ]
VB/VBA Source Code
Prevent Alt + F11 opening VB IDE in Excel
By:
Andrew Baker
Email (spam proof):
Email the originator of this post
Date:
Monday, August 21, 2000
Hits:
718
Category:
Unspecified
Article:
If you want to prevent a user from using the Alt + F11 to open the VB Editor in Excel then use the following: 'Purpose : Prevent user from opening VB Editor with Alt + F11 'Inputs : [bRestore] If True restores the Alt + F11 functionality 'Outputs : N/A 'Author : Andrewb 'Date : 21/08/2000 'Notes : 'Revisions : Sub DisableVBEditor(Optional bRestore As Boolean) If bRestore Then 'Restore Alt + F11 functionality Application.OnKey "%{F11}" Else 'Disable Alt + F11 functionality Application.OnKey "%{F11}", "" End If End Sub
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
