"Pick Fill Color" grayed out

J

Joshua Cooper

I'm running Office 10.1.5 on a Dual 1.25G G4 with Mac OS 10.2.8. I want to
use custom colors in my worksheets but the "Pick Fill Color" button on my
color picker is grayed out.

I performed a full install when I initially installed it so it shouldn't be
missing any features. Any suggestions?

-Joshua
 
J

J.E. McGimpsey

Joshua Cooper said:
I'm running Office 10.1.5 on a Dual 1.25G G4 with Mac OS 10.2.8. I want to
use custom colors in my worksheets but the "Pick Fill Color" button on my
color picker is grayed out.

I performed a full install when I initially installed it so it shouldn't be
missing any features. Any suggestions?

That's because you already see all the colors you can pick. All
versions of XL (Win and Mac) are limited to displaying 56 colors at
a time. This is a workbook-level property, so you can change any of
the 56 colors for a workbook to any of the ones available on your
system, but you can still only display 56 at a time.

To modify the colors, choose Preferences/Color, select a color you
don't want, and click Modify.
 
S

SVEN AERTS

What solution is the best for following:

I want to explain how to use an excel workbook I made...

In a first sheet, I explain how to use the workbook:

I wrote explanatory text is several buttons, quite big ones: about 1/4 of a
page. After having read the text, just click the button and it will bring
you to a next button.

In the macro it reads:
---
Sub GoToConclusions()
'
' GoToConclusions Macro
' Macro recorded 15-11-2003 by Sven AERTS
'
ActiveWindow.LargeScroll ToRight:=3
End Sub
---

But this LargeScroll ToRight:=3 ... If the button is moved at that spot is
moved... it makes no sense.
Is there another function to link a click to another button and that the
move follows whereever the button is placed ?

--
Sven-Brussels
GSM: +32 (0)485/389679
ExcelXv1-OSX.2.4.Jaguar-IBook-500MHz-640MB SDRAM-14GB HD-Airport-AZERTY
Keyboard
CHAT : ICQ UIN: 113835655 - YahooID: aertssven -
AOL Instant Messenger Screen Name: aertssven1 -
MSN Messenger Passport ID: (e-mail address removed)

For eco-techs & game for a better world, visit:
http://homepage.mac.com/aertssven
 
B

Bernard REY

Recorded Macros usually need some cleaning or even re-writing. I'm not too
sure to understand qwhat you're trying to do, but if you want to jump to the
next button, you could try this:

Sub Button1_OnClick()
ActiveSheet.Buttons("Bouton 2").Select
End Sub
 
S

SVEN AERTS

Thank you for your advice:

Your lines don't move the active window to where the button is it seems.
I tried following: doesn't work.. but I don't know why, can you help me?

Sub GoToBeginning()
'
' GoToBeginning Macro
' Macro recorded 14/10/2003 by Sven AERTS
'
ActiveWindow.LargeScroll To:=("Button 3")
End Sub
 
B

Bernard REY

SVEN AERTS wrote :
Your lines don't move the active window to where the button is it seems.

Maybe you should make sure you're using the right name for the button. I
found mine ("Bouton 2") recording a macro (names for the buttons may not be
too obvious). Did you?
I tried following: doesn't work.. but I don't know why, can you help me?

Sub GoToBeginning()
ActiveWindow.LargeScroll To:=("Button 3")
End Sub

LargeScroll can't jump to a specific address or object. You can only specify
a direction and a number of jums (like you did in your original macro with
"ToRight:=3"). See the VBA helpfile for more indications.

But, how did you get the name for the button? If it's a real name for an
existing button, I think the lines I sent should work. Just make sure
"Button 3" is the name of the button, then these lines should work:

Sub JumpToButton3()
ActiveSheet.Buttons("Button 3").Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top