| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Data before close in shared workbook?
Hi all, I have a workbook that when closed all the data in a named range is sorted by date in ascending order, however when i tried to share the workbook closing any open copy caused an error "Method of unprotect class failed" but i only have one sheet in the workbook locked and its not the sheet that is being sorted, i removed protection from the sheet and still get the same error, Any ideas? Simon. -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=394485 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting in a shared workbook | Excel Discussion (Misc queries) | |||
| Sorting Shared Workbook | Excel Discussion (Misc queries) | |||
| Sorting & Filtering in Shared Workbook mixing up data | Excel Worksheet Functions | |||
| Excel 2002 Automate shared workbook at close to save changes to new document | Excel Programming | |||
| Sorting data in a shared workbook | Excel Programming | |||
![Simon Lloyd[_638_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
