Recalcuting formulas and automatic loading

  • Thread starter Thread starter sbcelik
  • Start date Start date
S

sbcelik

I have just started to learn VBA and I could not find a way to
automatically running a function when the excel fine is opened.

Also would anyone help about recalculating formulas when a specific key
is pressed. I tried to use OnKey method but could not succeed.
 
In the Workbook_Open event in the ThisWorkbook module you can put your code to execute when the workbook is opened

If you have set the workbook's calculation to manual, you just need to hit F9 to request a new calculation

-Brad
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Cut/Copy/Paste in Excel 2010 0
How to get Last Key or Key-Combo Pressed (Not Event)? 0
Functions not firing! 2
Run macro when file is opened and closed 2
Problem with Calculating Worksheets 2
Active Cell problem 8
Copy Workbook, Formula Not Working 4
Deactivaion of recalc on load 1

Back
Top