Hi,
I currently have a code that runs when I open a workbook that simply refreshes all external data links, sorts information into order, saves and closes.
A couple of different websites that I'm linked to have issues with certificates, and a popup appears halfway through the refresh all...
Hi I have VBA code that I have written.......
It works but looks untidy.
Can someone offer advice on how to tidy it up with a loop so I can extend the ranges that are compared? (Extend to B3:30 & C3:C30)
Private Sub CommandButton1_Click()
'Security Pin
If...
Hello all,
I notice that my code is always running through my various selection change codes when I run a macro, is there any way I can have those bypassed while macros are running? I feel that would speed things up.
Hi
This is my first post, and I'm quite a newbie to VB so please be gentle.
I'm having an issue whereby the code that I've written (with a little help) to save the existing file as new, which checks to see if a file already exists with the same name, doesn't run as expected on first run after...
I have been searching for this without any luck.
I am looking for a code that will look at a very hidden sheet called "Approved Users" for a list of approved names that = their windows authentication (or login user name). If it is found then the password prompt is bypassed and they are allowed...
Hey All,
I have the following code that produces a summary from an excel workbook that that sends to an email address. The problem Is, I get the message "A program is trying to send an email message on your behalf". THis means it can't be automated in its current state.
Sub...
I was wondering if anyone can help me with this. (ps I'm new at vb but enjoying it immensly)
Sub AcceptPriceChangesClient1()
Range("c13:v13").Select
Run ("PriceChangesStep1") ' to copy range c13:v13
Sheets("1").Select
Run ("PriceChangesStep2") ' to paste...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.