VBA coding to go to cell not working (2000)

Topic

New Reply

For some reason the VBA coding to go to a cell automatically when the spreadsheet loads up is not working.
See attachment for coding.

Any help would be appreciated.

Reply | Quote

Replies

You have nested the Workbook_Open procedure within the Worksheet_Activate procedure. This is not valid for two reasons:
– You cannot ever nest one procedure within another one.
– The Workbook_Open procedure belongs in the ThisWorkbook module, not in the Sheet1 module.

Reply | Quote

How do l access the Thisworkbook module?

Reply | Quote

(Edited by Jezza on 07-Apr-06 14:22. To correct typo)

In the VB Editor click View| Project Explorer or Ctrl+R

This will open a panel where you can view the Excel Objects, one of these will be the ThisWorkbook, double click on it.

Reply | Quote

Thats great , may thanks for that.

Reply | Quote