AllowFormattingCells:=

[fivemantaiji]

This works fine on a PC, but not on a mac: AllowFormattingCells:=

I receive this back: Compile Error: Named Argument Not Found

Any suggestions on what argument should be used on a mac?

Thanks!

[tourneymgr]

This works fine on a PC, but not on a mac: AllowFormattingCells:=

I receive this back: Compile Error: Named Argument Not Found

Any suggestions on what argument should be used on a mac?

Thanks!

For clarification, "AllowFormattingCells:=" is an argument that's being used with the worksheets.unprotect method. (5man is helping me out with making my application mac-compatible).

[mikerickson]

On a Mac, you can not format cells on a protected sheet. Even unlocked cells. The functionality of the AllowFormattingCells argument is not supported for Mac.

(How's it going without Join, Split, or Replace?)

[tourneymgr]

(How's it going without Join, Split, or Replace?)

Yeah, I've got some splits and replaces to deal with, too. Arggg.

Is there someplace that has a comprehensive listing of the differences between excel for mac and windows? I've only been able to find bits and pieces on the web.

[mikerickson]

I know of no comprehensive listing.
Split, Join, Replace and ActiveX are the main ones I'm aware of.
File handeling uses different delimiters.
Some GUID stuff is probably also different.

I'm a Mac user and am waiting to see what 2008 will have.