A sliding sleeve device features a first sleeve that can be shifted with a dropped object on a seat and applied pressure to open a housing port. A second sleeve is in line with the first sleeve and be shifted to straddle the housing ports that we exposed when the opening sleeve was shifted initially. Snap rings or other locking devices can be used to hold the closing sleeve in the shifted position with the housing ports closed. The closing sleeve can also be shifted with a shifting tool that is run for example on coiled tubing. The opening sleeve can also optionally be shifted with a tool in an uphole direction to open the housing ports.