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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.