I have a working excel workbook that has VBA code and macros to help in data input.
I use a calendar to capture dates and read data out of cells. The application works 100% on my machine (application developed in
2007 but saved as a
.XLS – 97/2000 for compatibility in the office).
When I give the file to other people, the calendar control and the
TRIM() function do not work.
On my machine I can get to the references section but on all other machines in the office the
references function is grayed out. Any idea why a common object like the calendar and a common function like
trim() do not work on some machines