Did you enable macros when you opened the workbook?

Did you put the code in the correct location?

What happened when you tried it?

Rockbear wrote:

Hi :)
I tried bioth versions, no one worked
--
Just a regular user

"Gord Dibben" wrote:

Assuming that "open the sheet" means activate that particular worksheet in the
workbook.

Right-click on the sheet tab and "View Code". Copy/paste the code below into
that sheet module.

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Alt + q to return to the Excel window.

An alternate would be this code in the Thisworkbook Module.

Right-click on the Excel Icon left of "File" on the Menu and "View Code".
Copy/paste the code below into that module.

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
ActiveSheet.ShowDataForm
End Sub

Runs when the workbook is opened.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 09:15:01 -0700, Rockbear
wrote:

Ok :) have looked at it and have to agree thet it has all I need. Is there
some way to make it start when I open the sheet ?

A million thanks for the help guys



--

Dave Peterson