| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Share & "Un-Share" Worksheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Share & "Un-Share" Worksheets
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I share data in different worksheets? | Excel Worksheet Functions | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| How to share data between worksheets? | Excel Worksheet Functions | |||
| i want to share a workbook, but not all of the worksheets. | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
