SQL Replication

Just wondering if you can help me out with something or give me some tips. I am creating a SNAPSHOT and Transactional replication to various sites.

My co-workers don't think it will be possible to put the stored procedures into the Publication because of this: if they need to update the stored procedures with Steve's batch process, they can't be dropped and re-added since they are in the Publication. That generates errors.

Do, you know of any way to automatically pull something out of a Publication temporarily so it can be modified, and then put it back into the Publication? If not I won?t add the Stored Procedure on the publication.

Thanks,

Joel Collazo