Calculate Active Worksheet on Event from Personal Workbook

[myquan14]

Hello -

I have a workbook that is shared and edited by both PC and Mac users. Because of this I do not want to save it as a macro enabled workbook. When editing the workbook I like to have calculations set to manual and have only the active sheet calculate on an event change. I use the following code below. I am having trouble figuring out a solution where I can leverage a macro in my personal workbook to calculate the active sheet.

Does anyone have any suggestions?

Please Login or Register  to view this content.