Thanks,

The macro is just a simple print funtion that locks all the data in the
sheet before printing.

Range("B10:B45,E7:F45,H7:N45").Select
Range("H7").Activate
ActiveSheet.Unprotect
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
<--- this is where I want to move to the next sheet --

"Barb Reinhardt" wrote:

You may need to be more specific about what you want to do for the
"function". You may also get a quicker response in the programming group.
Post your code as well.
--
HTH,
Barb Reinhardt



"Kevin Mulvaney" wrote:

I cannot for the life of me figure out how to have a macro perform a function
and then select the next sheet. I can get it to go to a specific sheet,
either by name or index, but I just want to go to the next sheet.