bypass

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...