Cyberdude
10-03-2006, 02:00 PM
I have a problem that I'm hoping will be solved by using the ".Calculate" method. When I read Help about .Calculate, it says that I can use it to:
1. Calculate a range, or
2. Calculate a sheet, or
3. Calculate ALL open workbooks.
What I would like to do is calculate a single workbook when it is opened (not ALL workbooks that happen to be open at the time). Can a single-workbook calculate be done? If it can be done, how do I do it?
1. Calculate a range, or
2. Calculate a sheet, or
3. Calculate ALL open workbooks.
What I would like to do is calculate a single workbook when it is opened (not ALL workbooks that happen to be open at the time). Can a single-workbook calculate be done? If it can be done, how do I do it?