[mso] Re: Custom function in Paste function, add to tool bar?
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 19 Sep 2003 19:33:58 +0100
Don,
The best thing to do would be to copy the module to your Personal Macros
Workbook. You could then just type the function straight into any cell
on any workbook, just like you would SUM, COUNT, or any other function.
It only becomes a problem if you want to share the sheet with other
users, when you'd need to copy the module to the workbook itself.
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Donald Smith
Sent: 19 September 2003 18:58
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Custom function in Paste function, add to tool bar?
Yes you are correct and it is written to perform specific calculations.
I
understand now why you are questioning this and it is probably why what
I
am asking is not available, but I must semi-duplicate the spreadsheet on
a
regular basis so the formula must be entered on a regular basis also, as
the spreadsheet changes the size of the sheet changes ever so slightly
so
the formula must be entered in different columns. So I go to paste
function, user defined, and highlight my custom function.
The only reason why I ask is I have created special toolbars for
spreadsheets so most operations can be done in a single click. This one
probably won't.
Thanks
Don
Ps. Sorry if this turned into a double post as my trigger finger
malfunctioned.
Thanks Again
Don
Subject: [mso] Re: Custom function in Paste function, add to tool bar?
From: "Ray Blake" <ray@xxxxxxxxx>
Date: Fri, 19 Sep 2003 18:06:54 +0100
------------------------------------------------------------------------
---
-----
If it's a function, then it belongs in a cell performing calculations. A
function can only work in this way, since it doesn't actually do
anything other than calculate a value.
Can you tell us a little more about what this custom function does?
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Donald Smith
Sent: 19 September 2003 17:44
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Custom function in Paste function, add to tool bar?
It is a "Function" that is in a separate module of the VB Editor. It
shows up under "Paste Function" not "Macros", I have made my own VB
Macro
Toolbar, but when I use the same techinque for the "Custom Function" it
doesn't show up (it seems because it is a "Function") It isn't a big
deal
as it would just save a few mouse clicks, but It just seemed to make
sense
that there must be a way. Who knows!
Thanks
Don
Subject: [mso] Re: Custom function in Paste function, add to tool bar?
From: "Ray Blake" <ray@xxxxxxxxx>
Date: Fri, 19 Sep 2003 16:44:33 +0100
------------------------------------------------------------------------
---
-----
Don,
Do you mean you've created a macro?
If so, this page shows you how to put it on a menu or toolbar.
http://www.hardin.k12.ky.us/res_techn/TeckyTips/Office97/Excel/adexcelti
ps.html
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com
-----Original Message-----
Behalf Of Donald Smith
Sent: 19 September 2003 15:23
To: mso@xxxxxxxxxxxxx
Subject: [mso] Custom function in Paste function, add to tool bar?
I have a custom function in Paste Function. I have searched hi and lo
and
cannot seem to find a way to put that function on its own tool bar
button,
is this possible?
Thanks
Don
---------------------------------------------
This message was sent using Road Runner's Web-based
e-mail.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
