Jase
08-09-2012, 06:15 AM
Hi All. I have a excel spreadsheet with certain marcos built in. I need a method to automatically calculate the sheet.
Such as;
Activesheet.CalculateFull
or an alternative to Ctrl +alt + F9
Ideally I would live to activate it when the user navigates using the sheet tabs in excel, so when the user clicks page 5 tab for example that sheet calculates. I could create buttons to go to next page/previous pages that trigger the calculation but ideally want it to go through users clicking on the excel sheet tabs. Can this be done by inserting a new module into the VBA?
:banghead: Thank you for reading!
Such as;
Activesheet.CalculateFull
or an alternative to Ctrl +alt + F9
Ideally I would live to activate it when the user navigates using the sheet tabs in excel, so when the user clicks page 5 tab for example that sheet calculates. I could create buttons to go to next page/previous pages that trigger the calculation but ideally want it to go through users clicking on the excel sheet tabs. Can this be done by inserting a new module into the VBA?
:banghead: Thank you for reading!