Floating Command Button or Userform

Hi.

I have a spreadsheet with multiple sheets (about 30) and lots of different sections on a couple of the sheets.

I would like to add some navigation buttons that to the sheets that have multiple sections, but I want them to float on the page.

I am uploading a sample workbook with 2 examples of what I would like to do. I am open to either type if I can get it to do what I want.

• I want the buttons/form to float on the page when scrolling, without having to click on a cell in the sheet.

• I want the buttons to only work on the specific active sheet (if using a form, I need it to not stay visible when the user leaves the sheet.)

• If using a form for the buttons, I want to remove the Label & X at the top of the form. (I don't want the user to be able to close the form.)

I realize all of this may not be possible, but thought I would try to make it work.

Any help is appreciated.

I want the buttons/form to float on the page when scrolling, without having to click on a cell in the sheet.

Please Login or Register  to view this content.

I want the buttons to only work on the specific active sheet (if using a form, I need it to not stay visible when the user leaves the sheet.)

Please Login or Register  to view this content.

If using a form for the buttons, I want to remove the Label & X at the top of the form. (I don't want the user to be able to close the form.)

Please Login or Register  to view this content.

Logit, thank you so much. I will give this a try and get back to you.