| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting Data before close in shared workbook?
It sounds like you didn't change the code to remove the lines that tried to
unprotect the sheet (and reprotect the sheet???). Simon Lloyd wrote: 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 -- Dave Peterson |
| Reply |
| 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)
Hybrid Mode
