When opening a new Excel file I need to click on a cell before it opens...

When opening a new Excel file by double-clicking on it, after Excel loads I need to click inside one of the empty cells on my startup sheet before the file will open. Any ideas how to fix this? I don't have this problem on other installations of Excel. Using 2007.

Thanks,

David

Hi,

In my very simple example I select cell C2 of Sheet2 upon the file opening.

This involves VBA code

Please Login or Register  to view this content.

You have to put this code in the ThisWorkbook project (Alt + F11 to go to VBA code, double click ThisWorkbook on the LHS), and also ensure Macros are enabled in the Excel used to open the file.

Just put the sheet name and cell in the code above and it should work, it works for mine and I'm on Excel 2007.

Helps if I attach the file.