HOW TO SEPERATE PROTECTED WORKSHEETS

[alcannady]

I have a workbook with over 80 worksheets. I've managed to use a macro to get each sheet protected so that the recipient can only maintain the cells that are unlocked. Now, I need to be able to send each worksheet to a unique recipient. Is there some way that I can save each sheet to an individual workbook (at the same time) or can I just send each worksheet to a recipient as an attachment and not lose my protection?

 

[SkipVought]

Hi,

Are you performing this in Excel from Excel? Post in Forum707.

How, in MS Access, via VBA Code? Post in Forum705

If the answer to either of these is YES, then you are in the wrong forum.

Skip,

_[red][/red]