so i wrote my vb for my spreadsheet on windows, and when i opened it in
mac excel i had to change a few things.....but eventually got it
working...except for data validation....whenever i hit the drop down
for data validation, excel crashes and i have to force quit.....i
thought it might be because the way the script was creating the
validation, but i tried making it through the tools menu but it did the
same thing...any thoughts?

Don't know what version you're using, but data validation works fine in
all MacXL versions, whether implemented in VBA or in the GUI. The first
thing I'd check is that your version is up to date, via AutoUpdate or at
MacTopia:

http://www.microsoft.com/mac/downloads.aspx

The next thing I'd try is, with all Office apps closed, delete your XL
and Office prefs files in the

~:Library:Preferences:Microsoft

folder (where ~ is your home directory). If you don't want to lose any
preferences, just rename the folder. Start XL and new preferences (and
folder, if needed) will be generated.

If neither of those work, I'd suggest you post in the

microsoft.public.mac.office.excel

newsgroup, with more detail on what you've tried.



In article <(E-Mail Removed)>,
"Nigel" <(E-Mail Removed)> wrote:

> so i wrote my vb for my spreadsheet on windows, and when i opened it in
> mac excel i had to change a few things.....but eventually got it
> working...except for data validation....whenever i hit the drop down
> for data validation, excel crashes and i have to force quit.....i
> thought it might be because the way the script was creating the
> validation, but i tried making it through the tools menu but it did the
> same thing...any thoughts?

well i found that if i start a new worksheet and set up validation it
works fine......so i dont know if my VBA is causing it error, or if its
because it was created in windows......all my vba are assigned to
buttons so none of them run unless i run them....so it seems like it
wouldnt be the VBA but im not entirely sure....

On Nov 28, 7:08 pm, JE McGimpsey <jemcgimp...@mvps.org> wrote:
> Don't know what version you're using, but data validation works fine in
> all MacXL versions, whether implemented in VBA or in the GUI. The first
> thing I'd check is that your version is up to date, via AutoUpdate or at
> MacTopia:
>
> http://www.microsoft.com/mac/downloads.aspx
>
> The next thing I'd try is, with all Office apps closed, delete your XL
> and Office prefs files in the
>
> ~:Library:Preferences:Microsoft
>
> folder (where ~ is your home directory). If you don't want to lose any
> preferences, just rename the folder. Start XL and new preferences (and
> folder, if needed) will be generated.
>
> If neither of those work, I'd suggest you post in the
>
> microsoft.public.mac.office.excel
>
> newsgroup, with more detail on what you've tried.
>
> In article <1164766018.712352.66...@16g2000cwy.googlegroups.com>,
>
> "Nigel" <horror1...@gmail.com> wrote:
> > so i wrote my vb for my spreadsheet on windows, and when i opened it in
> > mac excel i had to change a few things.....but eventually got it
> > working...except for data validation....whenever i hit the drop down
> > for data validation, excel crashes and i have to force quit.....i
> > thought it might be because the way the script was creating the
> > validation, but i tried making it through the tools menu but it did the
> > same thing...any thoughts?