VBA IF statement for command button?

[smods]

I need some code to say if A1 = Sunday then Print all sheets

else just print sheet 1, sheet 2, sheet 3, sheet 4

Cheers

Chris

 

[snowblizz]

See this thread:
http://www.mrexcel.com/forum/showthread.php?t=379378

If ActiveSheet.[A1].Value = "Sunday" Then
[code]Use examples from other thread

Else
End If
[/code]

 

[snowblizz]

Gosh darn, my edit time ran out when I tried to make it better. Anyway.

See this thread:
http://www.mrexcel.com/forum/showthread.php?t=379378

If ActiveSheet.[A1].Value = "Sunday" Then
Use examples from other thread
Else
ThisWorkbook.Worksheets("Sheet1").printout
 ThisWorkbook.Worksheets("Sheet2").printout
ThisWorkbook.Worksheets("Sheet3").printout
ThisWorkbook.Worksheets("Sheet4").printout
End If

Caveat emptor, you should look into defining parameters for the PrintOut, depending on how much and how you want it printed.

 

[smods]

Thanks but I need to specify which sheets to print.

It's either going to be all sheets if it's a Sunday or if not then it will be Sheet1, Sheet2, Sheet3, Sheet4 & Sheet 5

Chris

EDIT. Just seen the code you have added Thanks

 

[Jubjab]

Did you see the second reply? That and the linked thread should have all info you need.