Autosort release Select

[RobertCo]

Hello everyone, its been a while

I have a spreadsheet has multiple sheets.
On sheet 1 values are entered and formulas applied

On sheet three formulas read from sheet one and are updated automatically

I have added an AutoSort capabilty by
pressing Alt-F11 and choosing worksheet

then I entered in the following code

Please Login or Register  to view this content.

The sort is working as expected however, I do not have access to the page anylonger to make changes.
I am not sure how to release the Select once the page autosorts.

Any ideas ?

Thank you

[JBeaucaire]

Hi Robert.... Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used.

DO that before you get infracted, and I'll give you a very nice replacement for that macro.

[RobertCo]

Hi JBeaucaire, Thanks for the tip, and appologies for the lack of code tags, I do know better

[JBeaucaire]

Here you go:

Please Login or Register  to view this content.

This will only resort the data each time you bring up the sheet to the first time. You can resort at any time by just switching sheets and coming back.
=========
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)