Keeping Buttons (that include Macros) always visible on the sheet

[gheyman]

In my first row I have several Buttons that I created that have different Macro's for each.

Is there a way to always keep these buttons visible no mater where the user scrolls ? Right now if they scroll to the right they obviously fall out of view.

Not that below the first row I have a table that has many columns.

I am looking for a creative way so that the user always can see and use the macros without having to scroll all the way back to the left to see them.

Thanks
Greg

 

[dmt32]

Try using Freeze Panes & see if this will do what you want

• Select the cell below the rows and to the right of the columns you want to always keep visible when scrolling.
• Select View > Freeze Panes > Freeze Panes.

Dave