Rather than directly connecting the hardware wallet to the computer for transaction signing, you generate the transaction on the computer using a wallet such as Sparrow. Subsequently, you export it to a microSD card, insert the card into your hardware wallet, sign the transaction, and then return the microSD card to the computer for broadcasting.

Consider exploring Coldcard as an example.