Hi Ron,
after some time I am back. I would like to thank you for your help. It is
strange but I have not been able to format the Calendar in the file we were
talking about. At the end I have solved the question of formatting the
Calendar in another way. I have formatted the Calendar Object in other
workbook and after that I have copied it to my workbook.
Ron, I would like to ask for your help again. The form we have been
discussing is a Single one. On the base of this Single form I have prepared a
MASS form. This is supposed to be used in cases when more than one change is
requested. In this MASS form is in one line/row all info which is on a Single
form.
The problem is that I have frozen panes on the level of 4th row. On the
2nd row in the cell M2 I need to input a date. The 3rd row's height is 40.
The problem is that the line of freezing after the 3rd row comes through the
Calendar and all dates under this freezing line are also frozen and it is
impossible to input them to the cell. In my case I am able to input only
dates from the first row in the Calendar.
Do you have an idea how to solve it? One possibility is not to use frozen
panes but I would like to have panes frozen and at the same time to be able
to input all dates from the Calendar.
Ron, thanks a lot for your help in advance.
Drahos.