Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Event macro that targets specific worksheet
Hi, I have this macro and I need it to only target a specific worksheet when it runs. Any help would be appreciated. Code: -------------------- Private Sub Workbook_BeforePrint(Cancel As Boolean) Application.ScreenUpdating = False BeginRow = 40 EndRow = 70 ChkCol = 9 For RowCnt = BeginRow To EndRow If Cells(RowCnt, ChkCol).Value < 6 Then Cells(RowCnt, ChkCol).EntireRow.Hidden = True Else Cells(RowCnt, ChkCol).EntireRow.Hidden = False End If Next RowCnt Application.ScreenUpdating = True End Sub -------------------- -- retseort ------------------------------------------------------------------------ retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690 View this thread: http://www.excelforum.com/showthread...hreadid=514023 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help updating my macro to include a 2nd worksheet. | Excel Worksheet Functions | |||
Help with a macro to open to a specific worksheet | Excel Worksheet Functions | |||
I need help with a macro which will copy a worksheet and.. | Excel Worksheet Functions | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |