I am new to coding, like this is my first time trying to write a VBA code and its taken me days to just get what I have below. I can't seem to come up with a code to turn this Property on this individual sheet only to False upon opening the workbook.Īny suggestions on how to do this would be appreciated. However when I close and re-open the workbook, the EnableCalculation in the Properties, has been automatically changed to True. Calculation xlAutomatic I recommend disabling Automatic calculations at the very beginning of your procedure and re-enabling Automatic Calculations at the end. When I do it this way, the code works perfectly. To turn back on automatic calculation with the setting xlAutomatic: 1 Application. The problem is I need to manually go to the Developer tab, Properties, EnableCalculation, and select False. I have the following VBA code below on this worksheet. I have a workbook with a lot of different formulas and I have one worksheet in it called Map, that I need to not auto calculate, every time I enter new data into a different worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |