enable

I have a spreadsheet that has numerous macros within it across multiple sheets. I send this spreadsheet to others outside of my company, but the "Macros have been disabled. Enable Content" warning always shows up when the spreadsheet is first opened. I understand the security measures, but is...

I ran into a problem where some users do not have their macros enabled. I found several old posts about hiding pages and keeping one visible with a warning / instruction on how to enable macros. But I could not get any of them to work on office 365. Does anyone have a solution where I can...

Hi Everyone, I'm using office 2016 We have our excel documents stored in sharepoint. when people open it they get the "enable content" massage box at the top and the enable macros, Is there a way to switch any this off just for this document? Thanks Tony

The IF statement below was part of a larger macro and used to enable the wrap text option when it was run from Sheet2. If ActiveSheet.Name = "Sheet2" Then Range(Range("M22"), Range("M22").End(xlDown)).WrapText = True End If We have since added more worksheets to our file and would like to...

I am continuing to work on a 2010 AddIn that examines every file opened in Excel and password protects the worksheet and workbook if the opened file meets certain criteria. My current issue is that if the file has come from the Internet (or certain other locations), it comes into the Excel...

Hi, I have the below code and I have an issue of it running sometimes when it opens the Access dB, it needs to enable content. Is there a way enable content in the below code? I have tried a couple things but I do not think whatever I tried it even close to what is needed. Sub delete()...

I have searched my issue with no success so far. Hoping someone can point me in the right direction. I have a file with many checkboxes. For example: checkbox1, checkbox2, etc. I would like to check any checkbox and uncheck others at the same time. If checkbox1 is already checked and I click...

Is there a way to automatically enable content on every workbook? The instructions I find show to turn off protected view but even after doing that I have to enable content once on each workbook that I open. Other information shows to change the settings on the message bar but it never...

I have received a spreadsheet with several graphs. I have tried to create a template for some of these but right clicking on one of the charts and choosing save as template, but the "Save as Templete" is greyed out I would like know how to enable this. I have checked and the sheet is not...

Hi, Is there a way to enable a ribbon button if a column or row is selected and disable the same button if row or column is not selected.

hello all, this one is pretty self-explanatory. I have a button I want to press and search range S14:S40 and if there is any text in there add something to the end like A or Jones. that will enable me to redirect my spreadsheet to do an alternate calculation which I should have under control.

I am looking for VBA code to enable outlining on all protected worksheets in a workbook. I would like it to autorun on startup and work whether or not the protection has a password or not. Thank you

Hi I am trying to enable a ribbon button if a column is selected, I know I need to use the on selection change event but not sure how I do this, Can someone help please

It appears that MS Excel opens macro-enabled workbooks in one of three ways: (1) A pop-up bar that includes an "Enable macros" button; (2) A pop-up dialog box that includes an "Enable macros" button; or (3) No pop-up at all with a hidden "Enable Content" button maddeningly hidden within the...

Hi! I need to help with VBA code to allow Multi User Editing. VBA code below is not good for me, beacause every time I'm asked to save file and it's undesirable for me. How can I enable Workbook "sharing" if is Workbook opened? Thank you in advance. Private Sub Workbook_Open() If Not...

I am trying to improve the performance of my Power BI queries. From an SQL database I created two tables "Data-Historical" which is set for data pre-2018, I have also Unchecked both Enable Load and Include in report refresh "Data-Current" which is set for data in 2018, I have also Unchecked...

Hello. Is there anyway to enable minimizing, maximizing, resizing, and scrolling with your mouse in a userform? I noticed that my userform does not have these capabilities and I can't find the properties to enable this functionality. Any help is greatly appreciated. Thank you!

I am trying to disable a user button so that only certain users can use it. I want it to be restricted on initialisation but to enable based on a listvof authorised users based on their system login ID but for the life of me cannot work out how to do it. Any help would be appreciated. Cannot...

I have a several workbooks that utilized macros and I have been using for years. Lately, others have used them and have overwrote or moved some of my information. I have since found and or created ways to keep the average Joe from modifying them. These include creating startup / shut down...

Hello, I am trying to use the following code for disabling "save as" in workbook_before save event for preventing the user to save a new copy of my workbook. However, I want to enable "save" (as in when someone presses Ctrl + S). Here is my code: Private Sub Workbook_BeforeSave(ByVal...