Automatically Sort data in three columns when I update column E (Protected Sheet)

**pwhittak** · 03-08-2016, 11:08 AM

I need to automatically sort the data in Columns E B and G in a worksheet which is protected for changes.
The macro below is mainly recorded. It appears to work fine but when I close and op the workbook I get the following error

The workbook has to be recovered and the following error displays
Removed Records: Sorting from /xl/worksheets/sheet1.xml part.
There does not appear to be any data missing.

Does anyone know how to fix the error/correct the macro?

Please Login or Register  to view this content.

**alansidman** · 03-08-2016, 11:11 AM

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

**pwhittak** · 03-09-2016, 08:01 AM

Ok Alan you got me. I forgot about debugging. Tried this and it finds nothing. The macro runs like a dream until I save the file and try to reopen it again.

On further investigation it seems that the error only occurs the second time the macro runs.
If I open the file having recovered it save it over the original. Open it fresh run the macro by chaging a M to and X in column E, I can save and open no problem. If I make a second change it produces the error as before and has to recover the workbook. I think I need code to clear the sort settings each time?

""The workbook has to be recovered and the following error displays
Removed Records: Sorting from /xl/worksheets/sheet1.xml part.
There does not appear to be any data missing

.""

**pwhittak** · 03-09-2016, 08:12 AM

Hey Alan

Thanks for sending me down the right track. I added

Please Login or Register  to view this content.

in the line before sort keys added and it fixed the problem.

Automatically Sort data in three columns when I update column E (Protected Sheet)

LinkBack

Thread Tools

Rate This Thread

Display

Automatically Sort data in three columns when I update column E (Protected Sheet)

Re: Automatically Sort data in three columns when I update column E (Protected Sheet)

Re: Automatically Sort data in three columns when I update column E (Protected Sheet)

Re: Automatically Sort data in three columns when I update column E (Protected Sheet)

Thread Information

Users Browsing this Thread

Similar Threads

Transfer/update columns from 1 sheet to another + update chart & data selection

Data Valitdation List Update and Sort Automatically.........

Update link (Update values) on a protected sheet excel 2010

How to automatically update column in one sheet with values in the other sheet (w/o dups)

Automatically sort new data by multiple columns

Data Sort A Protected Sheet

Copying (Master) column to another sheet to automatically update

Bookmarks

Bookmarks

Posting Permissions