When my workbook opens I want it to always open to "sheet1" which I
have renamed as "Menu" and the active cell to be D7.

This menu sheet allows the user to incert dates, however when the sheet
is opened it still has the last dates in place, is it possible to open
the worksheet "menu" and if there is anything in cells f4, f8, or f12
to delete it and then have the curser finish in active cell D7.

With thanks

Bob

Put this in a general module:

Option Explicit
sub auto_open()

worksheets("Menu").select
range("f4,f8,f12").clearcontents
range("d7").select

end sub


RJG wrote:

When my workbook opens I want it to always open to "sheet1" which I
have renamed as "Menu" and the active cell to be D7.

This menu sheet allows the user to incert dates, however when the sheet
is opened it still has the last dates in place, is it possible to open
the worksheet "menu" and if there is anything in cells f4, f8, or f12
to delete it and then have the curser finish in active cell D7.

With thanks

Bob

--

Dave Peterson

Dave,
Thank you.

Bob