D
Dylan
I have several protected formfields within a table to display calendar results.
I notice when I click away from the selected field; or cancel the calendar
dialog; or select within the field then outside of it, an error message comes
up saying "a valid date or time is required".
Is it perhaps possible to have a macro that selects a hidden formfield when
a protected cell in the table is clicked, but where it also recognises when a
cell containing a formfield is clicked so that it selects the field - and
does the on enter macro.
Regards
Dylan
I notice when I click away from the selected field; or cancel the calendar
dialog; or select within the field then outside of it, an error message comes
up saying "a valid date or time is required".
Is it perhaps possible to have a macro that selects a hidden formfield when
a protected cell in the table is clicked, but where it also recognises when a
cell containing a formfield is clicked so that it selects the field - and
does the on enter macro.
Regards
Dylan