Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
using the following code to avoid printing restrictions on a specific set of
user ids...what is the correct way to add additional user ids (e.g. User2, User3, etc) to the if statement? Private Sub Workbook_BeforePrint(Cancel As Boolean) If Application.UserName < "User1" Then Dim ws As Worksheet Cancel = True Application.EnableEvents = False For Each ws In ActiveWindow.SelectedSheets Select Case ws.Name Case "Daily", "Team", "Individual": ws.PrintOut End Select Next ws Application.EnableEvents = True Else End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count for multiple conditions in multiple columns | Excel Worksheet Functions | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |