How to Share & "Un-Share" Worksheets

C

crwiseman

I have a worksheet on a network drive that several of us share. I need
to control-copy a sheet to start a new sheet formatted like the current
one. But alas, Excel says that you can't do a control-copy on a shared
worksheet. How do I "un-share" the worksheet, do the control-copy
formatting, then re-share the worksheet? Thanks!
 
T

tdicapua

In Tools, "unshare" the worksheet, make your copy, then go back into Tools
and restore the "share" capability.
 
Top