Dave Peterson Wrote:
I think you're going to have to modify each of the routines that the
buttons
run.

Dim Wks as worksheet
On Error Resume Next
set wks = Me.Parent.Worksheets(Me.ComboBox1.Value)
on error goto 0

if wks is nothing then
beep
exit sub
end if

Then use wks as the worksheet in your other code.

Wks.printout

Wks.select

Wks.whateveryoudo


Where exactly is this placed... ? and does this go in conjunction with
the code above...? *sigh* im so lost... hah.


--
jaysen
------------------------------------------------------------------------
jaysen's Profile: http://www.excelforum.com/member.php...o&userid=24120
View this thread: http://www.excelforum.com/showthread...hreadid=380698