save first sheet only

hi guys sorry to bug you all again but i really need to get this done for my boss and im at my wits end
i have tried to change this code to save just the first sheet
and was wondering if anyone could hel me fulfil this as i keep getting an error
i will make the code red as to what i have changed

Please Login or Register  to view this content.

hi simon
really appreciate the reply
but ive tried everything and obviously ont want to mess up everything
so i would be most grateful if you could tak a look in yur own time and get back to me
thanks so much

im not sure where to put it and what to take out dave

if anyone could help i really would appreciate it

i have just tried simons code to where i thought it should go and i get
compile error
expected end sub

this is the part i changed

Please Login or Register  to view this content.

im getting paranoid now lol
surely someone understands this piece of code.
willing to pay for help

simon ( or anyone )
i changed the code you put to

Please Login or Register  to view this content.

as sheet 1 is actually caled PURCHASE ORDER but it still comes back
with the same problem

bump bump bump
this is d day
hopefully the boss will forget

cant get either of them to work either simon
but thanks for the effort

thanks simon
much appreciated

cheeers for the effort gummi
but that doesnt work either
;(

bump bump bump

bump bump bump