Home Excel

Macros and VBA

14 Conversations

Latest Activity

Custom List Message Item

How to assign ESC key to close any open VBA UserForm?

 

8 Views
0 Reply

Hi,

 

I am facing the below mentioned error, The VBA code run perfectly in my system, While using the same macro to another system it shows the below mentioned error:

 

"The error commonly occurs when code is incompatible with the version, platform, or archit

... Read More
73 Views
5 Replies

Hi,

 

I am attaching the Error Screenshot...

Error.jpg

Regards,

Arvind Kaushik

Read More

What are the best ways to protect the VBA Source Code from copying and publishing?

25 Views
0 Reply
Hi,

I was asked to create a report according to the chiefs (Chief 01, Chief 05, Chief 09...) found on the data base. I recorded a macro and assigned it to a button that would create a Pivot Table, however whenever I try to play it for a second time, it sho... Read More
24 Views
0 Reply

I have a large data query file with a few sheets containing pivot tables. I need to add a button to the first sheet that will refresh all the pivot tables in the file.

62 Views
4 Replies

Also, when you say Data Query file are you using Power Query and do you want the queries to refresh also,  in which case my PivotCache suggestion won't do it for you

 

This

... Read More

HI Pierre

 

If you do want to go down the Macro route rather than using the Refresh All button then I'd suggest adding this code to a module.

 

Best to avoid any hard coded r

... Read More

Dear Pierre,

 

First and foremost, add the (Developer Tab) to your Excel Ribbon, and follow these steps:

 

  - Go to Insert at the Developer Tab, and click on it.

  - You will

... Read More

Hello Pierre

 

Excel already has such a button on the ribbon:

Data -> Connections -> Refresh All

 

You could also put it in the Quick Access Toolbar if you don't want to switc

... Read More

i have a column of numbers that are color coded (to represent a specific mfg department) and I need to total the values by color.  Meaning I need to total all the values that have the same background color.  

 

I have done an exhaustive search online and wa

... Read More
188 Views
5 Replies

Hello,

 

take a look at this question in the Microsoft Community formerly known as the "Answers" Q&A forum. (I know, the "Community" site name is confusing to have on two d

... Read More

Hi matt nipper,

 

since you mention that you "have done an exhaustive search online" i have come up with a solution for you, although it has a rule that it will only work,

... Read More

@Mourad Louha's suggestion of an extra helper column for a sumif is by far the safest and most easily understood option.     

Read More

Hi Matt,

 

may be using the SUMIF or SUMIFS functions could help. You can define as criteria the same criteria you defined for the conditional formats. And, you don't need

... Read More

Hello everybody,

 

we have a new policy that says "Disable all except digitally signed macros". So all Excel files with macro feature need to sign. I need to find a solution how we could sign over 10k excel files in bulk. Is there any solution with powershe

... Read More
54 Views
0 Reply

I am trying to record a macro that generates a new sheet featuring a template for entering client details and creates a line on the master sheet that autopopulates based on future inputs from this new sheet. Any thoughts?

64 Views
1 Reply

HI Mike

 

That sort of thing is doable but a fair bit of coding involved.

 

When you say you want it to generate a new sheet, is that just a one off, or does it need to be ab

... Read More

I have 10 worksheets in the same format labled S1 thru S10.  I have another worksheet for data entry.  Each row contains data to be copied to one of the other 10 worksheets.  The destination is defined in a cell in that row, e.g. S5.

What is the syntax to

... Read More
119 Views
4 Replies

Hi Bob

 

Does the input sheet get cleared out after the data is copied to the other sheets?

Hi. I have a problem to open on my Macbook Pro Mid 2012 my worksheet with Macro. On my imac the worksheet can open without problem. On both machines is the OS El Capitan with Mac Office 2011 installed. but on my Mac it shows me the Runtime Error 5. I inst

... Read More
207 Views
2 Replies

Hello,

 

do you have access to the code?

 

I am asking, as according to your screenshot, it seems that the application has been provided by a company/developer. If you don't

... Read More

I'd like to click on a phone number cell in Excel and have that number sent to my Polycom IP 550 and dialed. The PC and phone are connected via ethernet (Peer to Peer). Looking for help on this... Is there a feature I'm missing, or a macro or VB script I

... Read More
75 Views
0 Reply

If you ever get this happening to you then suprisingly DROPBOX may be the cause.

 

Warning.PNG

 

My Linked in Article explaining the issue

 

Read More
263 Views
6 Replies
@Jon Peltier - have you repro'd this? If so, can you tell me how to repro it here - we'll reach out to Dropbox and ask them to fix it. Read More

Sounds like an issue that should be reported to Answers
http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

Read More
It's not Dropbox per se, it's the Dropbox Office Badge, which is intended to integrate Office with Dropbox, so people can collaborate on documents shared on Dropbox. If y... Read More

Hello,

 

I Would like to understand what is the function of this comumunity, because we also have MSDN and technet.

 

 

185 Views
3 Replies
No they won't, but communities will merge over time.
Great point, and it is something we are working on. Overtime you will see this become the official and only Community for MS solutions. Our support forum (answers) is and... Read More
Best Response

Today, we are pleased to announce the general availability of the Microsoft Excel REST API for Office 365

 

Nowdevelopers can use Excel to power custom apps. Excel is an indispensable productivity tool; users across all industries and roles embrace it. It i

... Read More
126 Views
0 Reply