how to make workbook open code specific to a sheet

[whitwoo]

I have the following piece of code that works with no problems when associated with a specific sheet Sheets("IAMT") however I would like to move this code to the Workbook_Open() function but I don't know how to bound this to reference the specific sheet.

The code is as follows

Please Login or Register  to view this content.

help much appreciated

[mehmetcik]

Right click on your sheet name at the bottom of excel and select view code

paste this into that module. [ All macros in that module are sheet specific ].

[CODEPrivate Sub Worksheet_Activate()
For Each Cll In Range("F3:FF3")
If Cll.Value > DTPicker22.Value Or Cll.Value < DTPicker21.Value Then Cll.EntireColumn.Hidden = True Else Cll.EntireColumn.Hidden = False
Next Cll
Application.ScreenUpdating = True
End Sub[/CODE]

[JieJenn]

Maybe point the macro to the IAMT worksheet first?

Please Login or Register  to view this content.

[whitwoo]

I think you or I have miss understood - I want the code to run when opening the workbook so I think I need to place the code in the Workbook_Open() function.

The same code also runs on the page and is ties to a datepicker change.

I am a complete novice so I may be way off the mark

[whitwoo]

JieJenn

I tried your suggestion but got a 'Compile error: Sub of Function not defined' when I open the workbook

Please Login or Register  to view this content.

[JieJenn]

Can you post your workbook?

[Norie]

Is the code you posted located in the module of the worksheet the datepicker is on?