Forum Discussion
Freeze Panes Question
To do what you want, you'd have to move all items you want on permanent display to the top left corner, but that will become crowded:
Hmmmm.... I don't quite get why the vendor and category slicers had to move to the corner along with others, especially since the top section is frozen in place. From what your saying I would just need to move my inventory/order sheet buttons up in the frozen area at the top since there is no clear work around for the side column to be frozen in place while vertically scrolling unless I want to use a VBA macro to make my buttons move while scrolling.
Well, I kind of figured that would be the response from the research I gathered. So, I ended up moving the inventory/order sheet buttons from the side of the worksheet to the top. I modified them so they look more button like and made them dynamic so that when they are selected the button is highlighted and prominent on the screen. Although I couldn't get the navigation sidebar to be stationary. I thought this was a good work around.
Thank you for your help
