I have a very large workbook with several worksheets. All have extensive formulas and conditional formatting. Data entry is very, very slow. Is there any code that I can add to my existing VBA that would open the workbook set to manual calculations so that data entry is not bogged down? And then close (or save) the workbook by reactivating calculations to automatic? My current VBA code is listed below. Thanks to any help you could provide.
Please Login or Register to view this content.
Maybe you could try something like this.
In Thisworkbook-module.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
bakerman2, that did not do anything. Unless I am placing it in the wrong way. I am a novice.
In the left pane of the VBEditor you have all the sheetnames listed below eachother.
As last one in the list you will see ThisWorkbook. open that and pase the code in the right pane.
Save your workbook, close it and reopen it.
Wonderful solution! Thank you so much bakerman2!
You're welcome, glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks