PDA

View Full Version : AllowFormattingCells:=



fivemantaiji
12-04-2007, 09:37 AM
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
12-04-2007, 01:45 PM
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
12-04-2007, 06:33 PM
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
12-04-2007, 08:00 PM
(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
12-04-2007, 08:11 PM
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.