application

Guys, Please can anyone throw some suggestions on the error when the script is run turns the excel file property to read only.

Please I need help for this error,Please Help me anyone

Hi, Is it possible to run a macro without "Application object" for example: Public Sub process() Application.DisplayAlerts = False Application.ScreenUpdating = False ' ' ' ' (program) ' ' ' Application.ScreenUpdating = True Application.DisplayAlerts = False ens sub in above example I...

Hi all, New here and pretty new to Excel formulas and VBA, so bear with me... when I select a value from a drop down in column B on sheet 1 I need a lookup to a table in sheet 2 to loop through the table and set all the rows on sheet 1 where A1 matches in sheet 2 A1. the number of rows can...

Good afternoon, I have the following code which works well at resizing all the pictures to a set size. I can't however work out how to centre all the pictures at the same time though! Sub Resize_Images1() Dim i As Long With Application .ScreenUpdating = False: .DisplayAlerts =...

Hi I know I can not enter that date 31/12/1899 in excel because the first day is 1/1/1900. What to do if I have application need to enter date in 1899? excel wont be good choice for that application for example? Thank you.

I have some VBA code that I turn screen updating off to keep the screen from flashing, then turn it on later just before I end, however part of my code is doing some copy pasting, so if I turn it on after I do the copy paste, I don't see any of the data that is copy/pasted. If I turn it on...

Hi. Apologies if I haven't got this right or if the thread exists -this is the first time I've posted. I've set up some code to switch off that pesky Autorecover. Below is the code in PERSONAL.xlsb:ThisWorkbook: Public WithEvents App As Application Private Sub Workbook_Open() 'runs once...

Set arg1 = Workbooks("COMM_COMBINED_INDEPENDENTS.xls").ActiveSheet.Range(Cells(7, a), Cells(e, a)) I have been looking at this line for a while now and I can't seem to determine why I am receiving the error "Application Defined or Object Defined Error". I have all the variables on a watch...

Hi I need to show the date of last activity on a report. In my head, I should use the IF function but cant get it to work. My logic is as follows: =IF(Retailer_Name,D7,MAX(App_Date)) Retailer_Name = Retailers names as defined as a data range in worksheet App_Date = date of application defined...

Greetings, I am receiving an application defined or object defined error on this line... not sure why this is giving me an error. Variable values are defined as integers. Looks similar to many of the example online, but... My intention is to set a range object that changes within a loop. Set...

Hello, using vba or otherwise, how to protect file excel from hacking via Application for example crack password excel, passware kit

You know how you can put a spreadsheet on a shared drive, and then anyone can use it, but only one person can use it at a time? Well, I just got around that limitation. :) I work for a huge law firm. We send our closed case files to offsite storage, but we frequently have to bring some of...

Hi all, Scenario: a vb.net Program is currently reading some informations from a workbook open in the Application. This may take some seconds. Is it now possible to detect in vba that this currently happens. Thanks Peter

I am new to VBA and having trouble. I have created a button that i want to prompt a pop up input box that triggers the user to enter a range of cells. I then want to use that range in a formula. However, doing so through the vba may be over my head at this point but if it is a simple process...

I need some help with how to best design an application. The current structure of this application uses hundreds of formulas across all of the sheets. The vast amount of formulas is drastically slowing down the processing of the application. With that said, I'm trying to find alternative...

Hello, I know this must be easy, but my brain doesn't work right whenever I try to do this... I have a list of dates in column B. They are formatted as text like this: 01/28/18 01:18:05 I need to convert that to mm/dd/yyyy in column C so that I can copy and paste that into another...

Hello Guys, I want to hide Application events like status bar. formula bar in specific file. I tried workbook events also it is affecting other workbooks too. Any other possible solutions? Thank you.

Hello! I have a list of computer system down time tracked in % of time with a 24 hours period. The following is an example: System Name Down Time Date Application X 100.00% 01/01/2018 Application Y 2.50% 01/02/2018 Application M...