- Hiding active workbook programmatically in Excel. I'm working on a VBA project based in a workbook. The code opens a new workbook and calls an external API which downloads and inserts a bunch of data in multiple worksheets of this new workbook. I deactivated Screen Updating ( Application.Screenupdating = False) so initially.
- Make Excel Invisible and Hide Excel. The entire VBA Excel program is available for downloading at the bottom of this web page, enjoy! Application.visible = flase will hide the complete appltion,so all the open workbooks loose the visibility,can any help with the code to hide only one workbook not using Activewindow.hide.
- Excel VBA Development We accumulated the necessary experience in developing applications that are easy to use by our end customers and are easy to maintain and update by our own developers. You can expect the high level of quality and usability as you see in our own projects.
Learn how to make your Excel program look more like a regular program - with Excel being hidden and your Userform being on display only! This is a HUGELY requested topic and there are several.
Hides an object but doesn't unload it.
Syntax
object.Hide
The object placeholder represents an object expression that evaluates to an object in the Applies To list. If object is omitted, the UserForm with the focus is assumed to be object.
Remarks
When an object is hidden, it's removed from the screen and its Visible property is set to False. A hidden object's controls aren't accessible to the user, but they are available programmatically to the running application, to other processes that may be communicating with the application through Automation, and in Windows, to Timer control events.
When a UserForm is hidden, the user can't interact with the application until all code in the event procedure that caused the UserForm to be hidden has finished executing.
If the UserForm isn't loaded when the Hide method is invoked, the Hide method loads the UserForm but doesn't display it.
Example
The following example assumes two UserForms in a program. In UserForm1's Initialize event, UserForm2 is loaded and shown. When the user clicks UserForm2, it is hidden and UserForm1 appears. When UserForm1 is clicked, UserForm2 is shown again.
See also
Excel Hide Vba Code
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Active8 months ago
Is it possible to hide VBA code, normally accessible from Excel's VBA Editor (Alt-F11), from a user's prying eyes? Can I, for instance, sign it with a digital signature?
Standard VBA project password protection is not suitable in this case because it can be cracked relatively easily.
Community♦
Abhijit ShelarAbhijit Shelar49155 gold badges1515 silver badges3838 bronze badges
1 Answer
Yes. In the VBA main menu, click on Tools | VBAProject Properties and under the tab 'Protection', Check the box 'Lock project for viewing' and enter the password.
Save and exit the Excel file. When you open it next the code will be hidden.
Sid
w5m1,52533 gold badges2020 silver badges3838 bronze badges
Siddharth RoutSiddharth RoutExcel Vba Hide Application Template
123k1515 gold badges163163 silver badges218218 bronze badges