PLEASE HELP ON FORM QUESTION

[Tom]

In creating a form, in EXCEL 2001 for Mac ...

1. I used option buttons and check boxes, but the fonts for
both are not what I'm using in the rest of the sheet. How
can I format the fonts?

2. One of my entries in the form is for a date in mm/yy
format. However if you type 05/02 for May of 2002, it
displays 05/03, having entered 05/02/2003 into the cell.
How can you make it so the user can just type the REAL
mm/yy and get the proper mm/yy to display.

3. For reasons unbeknownst to me, when I open this form I
now get a dialog box telling me it has Macros which may
contain viruses and do I want to disable them. (If I click
disable, it says it's an Excel 4 macro that can't be
disabled) I didn't deliberately write a Macro and can find
no listing of a Macro under the Macro menu option. How can
I eradicate this message or disable?

 

[Bob Greenblatt]

In creating a form, in EXCEL 2001 for Mac ...

1. I used option buttons and check boxes, but the fonts for
both are not what I'm using in the rest of the sheet. How
can I format the fonts?

2. One of my entries in the form is for a date in mm/yy
format. However if you type 05/02 for May of 2002, it
displays 05/03, having entered 05/02/2003 into the cell.
How can you make it so the user can just type the REAL
mm/yy and get the proper mm/yy to display.

3. For reasons unbeknownst to me, when I open this form I
now get a dialog box telling me it has Macros which may
contain viruses and do I want to disable them. (If I click
disable, it says it's an Excel 4 macro that can't be
disabled) I didn't deliberately write a Macro and can find
no listing of a Macro under the Macro menu option. How can
I eradicate this message or disable?

1. I'm not sure you can change these fonts. You can try changing the normal
style but I won't guarantee that it will work. Unfortunately, I can not test
with Excel 2 001 at this time.

2. Excel must recognize that what the user is typing is indeed a date. If
the user types 05/2003, and you format the cell as "mm/yy" then it will
appear as 05/03 as you expect.

3. I think Excel sees the forms objects and thinks there is an XLM macro
sheet. Unfortunately, you can't change this.