Quote Originally Posted by p45cal View Post
Consider putting the buttons on a modeless userform.
In the attached is such a userform.
If it doesn't appear then switch to Sheet1 from another sheet.
I've not bothered positioning it etc., but it remains where you leave it and allows you to edit the sheet normally while it's still showing. Yes you can prevent the user from closing it and you can cause it to disappear when you switch to another sheet.
The userform doesn't have the ability to create the same style I wanted, but that's okay - I'd rather have the functionality over the aesthetics. This works brilliantly. Thank you!