There are two different types of buttons in Excel: those from the forms
toolbar and those from the control toolbox.
AFAIK you can't control the colour of the ones from the forms toolbar.
Control toolbox buttons aka Command buttons do have a BackColor option
that can set the button's colour. This dropdown has two tabs: System
and Palette (or at least it does in Excel 2003). To get all the
colours, you need to go to the palette.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Roger
Sent: Monday, 21 November 2011 06:50
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Re: Opening a workbook automatically always to the
same Sheet (and Range)
Thank you for your comprehensive answer. With the right keyword, I was
finallly able to get the opinion of the Help file on the matter: it does
not mention anything like a /x macroname option for executing a macro.
With that established, I didn't feel like researching off-beat parsing
and just pointed my Auto_Open() to the first of two Excel graphs I want
to link to optionally by button click in a PowerPoint slide show. And I
added a pushbutton next to each of the graphs to get quickly to the
other graph, with the Application.Goto() method set to Scroll:=True.
The only problem left is that the light grey buttons are hardly
distinguishable from the background, but I cannot get a red pushbutton
now, although I clearly remember I could get one, on my present system,
after a lot of research a few months ago, the details of which, possibly
involving VBA from the Immediate Window, I forgot. I find that the
pushbuttons for a form and the pushbuttons for a spreadsheet don't have
quite the same property sheet and the same capabilities, and my VBA
Editor doesn't see the desired properties where I want them. Besides,
the highly loaded spreadsheet on which I want to do this doesn't produce
pushbuttons that can have BackColor set to Highlight (=blue). So, for
the time being, the Excel buttons linked to from my slide show remain
faint, although I can get the caption in large bold at least.
Best regards,
Roger Belling
--- In ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ,
<david.smart@...> wrote:
>
> I'm not aware that Excel has a /x option. Do you have any URL links to
> a description of it.
>
> There are numerous web pages about retrieving the command line
arguments
> from a shortcut into the autorun macro. These could be parsed and used
> to run a selected VBA sub.
>
>
> Regards, Dave S
>
>
>
> ________________________________
>
> From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ]
On
> Behalf Of Roger Belling
> Sent: Friday, 18 November 2011 04:58
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
> Subject: [ExcelVBA] Opening a workbook automatically always to the
same
> Sheet (and Range)
>
>
>
>
> Can anyone suggest a way to make the /x MacroName parameter work in a
> (Windows Vista Business 2006) shortcut (and preferably for different
> macros from different shortcuts)? It worked for me sometimes, but the
> more I tried to use the feature, the less it worked reliably and with
> full flexibility. (One can theoretically get the same workbook opened
> to different sheets by different shortcuts specifying different macro
> names. I have had the equivalent working in Access for years.)
> I do get reliable operation if I use Auto_Open as a macro name,
without
> having to specify it in a shortcut, but it can open the workbook only
to
> one sheet and not to different ones on different occasions. (I use a
> modulo 2 counter on a sheet now that alternates which of 2 sheets it
> will open to.)
> Thanks if you can help.
> Roger Belling
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ----------
>
> Visit our website at http://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named. If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail. Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mails are not encrypted and cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message which arise as a result of e-mail
transmission.
> If verification is required please request a hard-copy version. This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities
> or related financial instruments.
>
>
> UBS reserves the right to retain all messages. Messages are protected
> and accessed only in legally justified cases.
>
> [Non-text portions of this message have been removed]
>
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar