turned

  1. L

    Workbook protection activates after every change

    I realize this is a dumb question. I originally costumized this workbook so that people at my old job could use it without editing any of the structure behind it. Now I'm back to working on it, but everytime I launch a macro and the like, the workbook protection gets turned back on after I'd...
  2. S

    unable to open file

    Good Morning I have an end user that can't open a 5 meg file. The pertinents are excel 2013, 32 bit, windows 10 64bit it is a macro enabled sheet came in email the file has references to external data. a very small cluster of users can't open it, but a large majority of user CAN. it's not...
  3. L

    TAB Order in Excel

    Hi, I have found various VB code to set the tab order in excel but this only works with sheet protection turned on. I am after something that will work with sheet protection turned off. The reason is I have some code for an activex combo box that doesn't respond, as it should, with the...
  4. G

    Formula Just Stays a Formula

    This is odd. I have a pivot table and whenever I reference to it, it just stays a formula (e.g., "=B47" and enter just stays "=B47"). Within the pivot table, I've turned off "Generate Get Pivot Data" so that it refers to the cells as normal. Calculation is absolutely turned to automatic. The...
  5. P

    Enable Events keeps getting turned off- How do I troubleshoot this?

    I have a workbook that I use for every client file I touch. For some reason, the enable events keeps getting turned off somehow. I figured I probably have application.enableevents=false at the beginning of a macro somewhere in the workbook, and then don't have =true at the end of that snip of...
  6. A

    Copying data onto another sheet, but omitting blanks.

    My spreadsheet is designed to track whether our freelancers have accepted work. I want to track which work they have turned down. Each row represents a work offer, and I want to have a column which tracks which freelancers have turned it down. Is there a way to mirror this data on a separate...
  7. R

    Excel Freeze Questions

    Hello We use Excel 2106 via office 365. We have had countless issue with excel freezing. We have tried a lot of things and nothing seems to really fix it. The freezing isn't consistent, they happen when moving from cell to cell or saving, etc. We have turned off annual updates and went to...
  8. P

    Cannot Locate The Internet Server or Proxy Server

    Hi, I'm hoping someone can help solve this riddle for me. I'm getting the following message in Excel after testing a hyperlink I embedded: "Cannot Locate The Internet Server or Proxy Server" I've created hyperlinks before without this issue while using the same Excel version and Macbook...
  9. B

    Excel VBA speed before and after restarting computer

    Hi, I'm experiencing some problems with excel run times but only after the macro is run once after a computer is turned on (or restarted). The macro mainly involves opening multiple workbooks, exporting csv files, reading and writing data across workbooks. Every time I run the macro for the...
  10. E

    Is this a big in Excel 2013 or is it me (VBA Screenflickering)

    Hi All I have a spreadsheet with multiple shapes Based on a selection i make - i hide a picture and display the relevant picture The problem im having is that the screen flickers before it displays the shape I have tried Application.screenupdating to false, turned off the calculation...
  11. V

    VBA - Go To Error Handler if Macro Interrupted

    Hello, Is there a way to make excel Go To my Errorr Handler if Esc is pressed half way through a macro running? This is to make sure things like Events and Screen Updating are turned back on if a macro doesnt reach it's end and does it itself. Thanks

We've detected that you are using an adblocker.

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.
Go back
Back
Top