Oct 28 2021 11:41 AM
Hi,
I am designing a calendar as a vacation tracker for my company. I added a Scrollbar to it so, scrolling is done more easily. Employees are only supposed to type “V” for vacation and “F” for flexible day leave under the desired dates. The problem is that when I type V or F if I scroll using my Scrollbar, the V and F will move within the calendar. So, we won’t be able to know exactly which days our employees were on V or F. I truly appreciate your help.
I am using Win10, Excel 365 on my System.
Oct 28 2021 01:05 PM - edited Oct 28 2021 01:05 PM
SolutionThe scrollbar changes the dates in H8:NH8. This is not desirable. So I'd remove the scrollbar, and let users use the built-in scrollbar at the bottom of the sheet.
Oct 29 2021 08:23 AM
@Hans Vogelaar Thank you.
Oct 28 2021 01:05 PM - edited Oct 28 2021 01:05 PM
SolutionThe scrollbar changes the dates in H8:NH8. This is not desirable. So I'd remove the scrollbar, and let users use the built-in scrollbar at the bottom of the sheet.