Hi all,
I developed a program with different controls to limit / pilot different activities; the VBA is triggered by the events of the sheets and / or of the entire workbook; unfortunately the user can bypass them all by pressing the pause button in the development environment (Alt + F11) bar Immagine.png, which can also be done if the VBA is protected !.
How can this user action be blocked?
Thanks in advance for all the response
Add one line to your code
Please Login or Register to view this content.
Thanks Jindon for the suggestion but I need something permanent while the indicated command does its job only during the execution of a VBA routine.
On the contrary, in my case, it should not be possible to pause the VBA when there is no code in execution: to be sure it will start at the given event.
I don't think you can do it "permanently" AFAIK.
You have to do multiple things:
1. disable cancel and escape
2. disable Alt-F11
3. remove the ribbon
4. hide and protect all sheets and encrypt key parts of your sheets so they are unusable unless VBA is enabled. Enabling VBA would decrypt it, unhide the sheets and unprotect the sheets selectively.
I also created my own custom menu over the top of the header menus, and my own shortcut menu so that everything is controlled.
' prevent interruption of code
Application.Interactive = False
Application.OnKey "{ESC}", ""
Application.EnableCancelKey = XlEnableCancelKey.xlDisabled
' disable Excel menus/ribbon to make it more presentable when you switch to this Excel file
Application.ScreenUpdating = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.ActiveWindow.DisplayHeadings = True
Application.DisplayFormulaBar = True
Application.FormulaBarHeight = 1
Application.DisplayStatusBar = Not Application.DisplayStatusBar
ActiveWindow.WindowState = xlMaximized
Application.Interactive = True
Last edited by superlative; 09-25-2019 at 10:22 AM.
Thank to all, collecing your help I solve my problem with the following code
In ThisWorksheet events I put:
In a standard modulePlease Login or Register to view this content.
Plus, using UI Editor, I add a "Office 2010 Custom UI Part" item to disable idMso="VisualBasic and idMso="DesignMode"Please Login or Register to view this content.
(I can't write the right code due to a block that prevents sending of a string with html)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks