turned

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

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

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

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

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

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

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

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

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

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

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