Sharing an individual worksheet rather than the entire workbook

[mridgeway]

How do I share one individual worksheet rather than the entire workbook? I often have to share one worksheet of a large workbook with a coworker. Right now, I copy the one worksheet and save it in its own workbook but was wondering if there was an easier way.

 

[gruntingmonkey]

I'd say there was no easier way then what you are doing right now.

There are complicated bits of code which would turn your process into a single click of a button... but I'm not sure that's what you're after? If the workbook is saved to drive where everyone has access, you could always put a password on the tabs so only the people with the passwords could use them?