Rabu, 25 Februari 2015

RE: [ExcelVBA] Creating my first Excel add in

 

It looks as though it is something you are doing wrong, but as I am here and you are there it is difficult to say what.

 

Does the other machine have a ribbon enabled Excel, are you creating the ribbon in Excel 2010/2013 and trying to view in 2007? Are you getting any errors? How did you add the ribbon to your file? And on, and on …

 

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
Sent: 25 February 2015 13:29
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Creating my first Excel add in

 

 

Bob,

 

I am unable to get a ribbon to travel with it. Is there something I am doing wrong? I create it on my desktop and then open it on my laptop or another user's machine and I do not see the same ribbon.

 

 

Jim Wagner


 

On Wednesday, February 25, 2015 1:25 AM, "'Bob Phillips' bob.phillips@dsl.pipex.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:

 

 

No, that shouldn't be necessary. The ribbon travels wit the workbook as well.

 

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
Sent: 24 February 2015 22:59
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Creating my first Excel add in

 

 

Bob,

 

I had tried it this morning and I think I must have done something wrong, because it worked this afternoon. I guess my question is now, I need to get the buttons off the sheet and put them on the ribbon. I will probably need to have the users import my custom ribbon file.

 

 

Jim Wagner


 

On Tuesday, February 24, 2015 3:46 PM, "'Bob Phillips' bob.phillips@dsl.pipex.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:

 

 

What makes you think that macros don't travel with the workbook?

 

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
Sent: 24 February 2015 15:04
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Creating my first Excel add in

 

 

Hello all,

 

I was asked to work on a sheet that many users will have access to, that tracks projects. It is a download that someone found on the internet and it is pretty bad. I can do better than that. There are buttons at the top of the sheet that they have to sort a column by date, another column by file name, another to  sort a column by day.

 

My thought was to create some macros and use them. Then add the macros to a custom tab on the ribbon. But then I found out that macros do not travel with the file. So I thought can an add in be used to travel with the excel worksheet?

 

I do not want to install macros on a lot of computers to make it happen. I just want to send the file and it work.

 

Thank You all for any advice and help.

 

Jim Wagner


 

 

__._,_.___

Posted by: "Bob Phillips" <bob.phillips@dsl.pipex.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
----------------------------------
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:

Poskan Komentar