Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

User defined buttons in Toolbars,transfer to another computer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
marko - 11 Dec 2005 12:21 GMT
Hi!
I made a button in my toolbar in excel for making  multiple copies of a
sheet. I made a Personal Macro Workbook and put my code into it because
i don't know how to make code that will be accessible in every excel,
if you know what i mean. So i assigned that macro to the my toolbar
button and it works just fine in any excel workbook i open.

Now my FIRST question: Is there an easy way to just write code in VB
and assign it to my button and that it works in any excel file that i
open on my computer?

My SECOND question: if I make my own defined MENU with my own commands
which have assigned macros(i wrote my code) can i transfer that menu to
another computer? Or can i maybe assign that meny and all the
macros(all the VB code) to some excell file and when i put that
workbook on another computer it will have my menues?
Thanks!

Marko
Dave Peterson - 11 Dec 2005 14:45 GMT
Yes, you can put macros in any workbook and have the icons on any toolbar
assigned to any of those macros.

But that becomes very difficult for organization purposes.

If you have macros that you want to make available to others, then put them into
a workbook, but don't save it as personal.xls (or personal.xla).  

You can only have one workbook open that has the name of personal.xls and if any
in your audience is already using personal.xls for their own stuff, it'll cause
heartache and pain.  They'll have to decide to keep yours or keep their own.

Instead, you can use a different name (MarcoUtils.xla, saved as an addin).

You could build the menu by using John Walkenbach's menumaker program:
http://j-walk.com/ss/excel/tips/tip53.htm

Then you can share this addin in a couple of different ways.

If each user always has access to a common network folder, you could put it in
that folder and tell the users to install it via:
tools|Addins
and browse to that folder.

Then you have one file to keep up to date.

If the users don't always have access to that folder, you could send them the
.xla file and tell them to save it to a nice local (C: drive) location.

Then use tools|addins to browse for your addin.

If you're really industrious, you could even give them a small installation
program that they run to install the addin.

Jan Karel Pieterse has a nice install program included in the .zip file for his
(with Charles Williams and Matthew Henson) name manager utility.

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp/

And if you use names in any of your workbooks, keep that name manager utility.
It's very helpful.

> Hi!
> I made a button in my toolbar in excel for making  multiple copies of a
[quoted text clipped - 15 lines]
>
> Marko

Signature

Dave Peterson

marko - 13 Dec 2005 19:22 GMT
Hi!
Sorry for this late reply, I couldn't get to the net! :)
I visited those sites from your post and they seem interesting and I
think i will make some good out of it. Thanks again and best regards,

Marko
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.