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

"crwiseman" wrote:


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!


--
crwiseman
------------------------------------------------------------------------
crwiseman's Profile: http://www.excelforum.com/member.php...o&userid=32758
View this thread: http://www.excelforum.com/showthread...hreadid=529787