Similar Posts
VBA Code to Send Outlook Emails
VBA Code to send Outlook Emails Sending bulk emails is a very common activity, there are many office activities that need a person to send bulk emails to single or multiple recipients. You also may…
How to Count Words in a cell?
How to count words in Excel using the LEN function along with other Excel functions. It also gives formulas for counting words or text, whether case-sensitive or not, in a cell or range.
How to Insert Data from Picture in Excel – Quick and Easy (6-steps)
If you have data on paper that you want to add to Excel, you can take a photo of it, save the photo to your computer, and upload the data into Excel. This saves time…
Top Excel Interview Questions and Answers – Quick and Easy
This article has Top Excel Interview Questions and Answers to test your Excel skills. It’s great for beginners who are just starting out, or even pros who want a refresher. The questions cover everything you might need for jobs like data analyst, business analyst, or accountant.
Excel logical operators: equal to, not equal to, greater than, less than
Many tasks in Excel require comparing data in different cells. To do this, Excel offers six logical operators, also known as comparison operators. This tutorial will help you understand how these operators work and how to write efficient formulas for data analysis
Bullet Points in Excel – 4 Easy Ways
Today, I’ll show you how to add bullet points in Excel with simple steps and clear images, so you can easily highlight key points in your Excel reports for better clarity and readability. Bullet points…
No use for this code since the user can click the more command menu and can select the navigation pane and others to return.
Thanks Sanal for your response. There are many other ways also you can bring the controls back like opening the Access file using Shift key. However the code placed in the Form load event should bring the controls back to hidden mode.
i have tried it in access 2016, and it doesn’t work in access 2016.
Thanks for your query Ivar. You can try following code that works with MS Access 2016: