prevent

I have users that need to disseminate data from files that are downloaded from SharePoint. My program does the job but the popup, "Uploading to SharePoint" slows down the process. When they are running wireless it almost complete stops the process. We do now want anything on SharePoint to be...

Hi, I am currently working on a sheet where I would need to prevent Columns A to G from being deleted. However, I should still be able to edit cell content in Columns A to G. Anyone has any solutions, perhaps using VBA, on how to tackle this? Many thanks in advance!

Is there an easy way to prevent a chart being split over two pages when printed? I have a chart at the end of a large amount of data which will resize depending on the data available. When the report is printed I don't want the chart to be split, I'd rather it was just on the next page in one...

Hi, I need the y-axis on my chart to autoscale, so that the major units will be 5, 10, whatever, as appropriate, when the values are large. But sometimes the values will be very small and the autoscale sets the major unit to 0.5. I am counting people who meet certain criteria, so this is not...

Hello, I would like to get the code to prevent pasting duplicate data in excel using VBA.

Hello, I have been looking but cannot find the answer to what i am looking to achieve. Is there any code that will prevent users hidding columns on a worksheet, I do not want to protect the whole sheet, but am finding different users hide different columns which then causes problems for others...

<code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "You can't save this workbook!" Cancel = True End Sub I can't seem to prevent the user from saving as and creating a new workbook, and yet still allow them to save the workbook regularly. </code>

In this thread: https://www.mrexcel.com/forum/excel-questions/1051620-running-macros-excel-2016-screen-flickering.html#post5049484 ... I was given the advice to use Application.ScreenUpdating = False on my entire code to prevent screen flashing/flickering while running the code (this issue...

I have a workbook of several worksheets and I want to deactivate the COPY SHEET for a specific worksheet named "Form". meaning I do not want a duplicate of this sheet to be created by pressing Ctrl key and mouse dragging of the sheet, How do I prevent right click or copy sheet function for that...

Hello All, Is it possible to prevent a tab, in a workbook, from being deleted, with out hiding it? Thanks

Is there any way to prevent users from coping data from protected sheet protected cells? only to allow them to copy information from unlocked cells? one more question. How to prevent users to paste information outside of active workbook to another excel or program file?

Hello internet! I want to prevent users from manually changing values of items in a pivot table. What are my options in doing this? I already tried protecting the sheet but this remove the capability for them to refresh the pivot. Any idea is greatly appreciated.

Hi, Im super new here. I have been trying to figure based on the old post. But seems i cant get it right. I tried to copy few codes that i found online to prevent the duplicate values on a data form that i created. Im trying to avoid duplication for range B2:B299 RowCount =...

I am using a double click to run some code. If the user double clicks an inappropriate cell, he get a message that the cursor is "out of range". If he clicks on a cell which is reading a value from another location, the code provides the message, but then selects the source cell for the...

Hi, i'm really new to VBA. i would like to know what should i do for my VBA files if i want to prevent any duplicating data in future. What commands should i use in the macro? for example if i'm doing monthly update data. tq.

In excel 2007 I could prevent users from unfreezing panes by protecting the workbook and checking the window protection, is there a workaround to achieve this again in these versions of excel where the window protection is greyed out?

I have a Textbox on a Userform and I want to disable the user being able to add a new line when typing, by pressing the return or enter key. Is there a keypress event which can be used to prevent this?

Hello Good Morning, I am new in VBA Excel and we have an assignment in our class on how to prevent duplicate in a range. Can someone help me in finding the code for this? Thanks. Bjorn18

I don't think there is an answer to this. I have an unprotected range on a protected sheet. When an end user moves the contents of cell C5 to Cell C4, C5 becomes protected. How do I prevent C5 from becoming protected?

Dear How it is possible to have formula set in a cell where i need to calculate an Average of cells containing certain text. For e.g. I have cells from 1 to 10 some contains "Prevent" and some contains "Detect" I want to have and Average percentage for Prevent only and Detect only Thanks