newly

I have a vba which creates a new worksheets whose name is dependant on a cell value. At the same time it also created a PDF file of the same sheet. What I want it to do is also protect the newly created worksheet only. I have tried a few things to no avail. This is what I have so far Sub...

Hi All~ I have a user that occasionally experiences this error -- "Update or CancelUpdate without AddNew or Edit" The db I administer has about 20+ end users, split db, front end accde files on each users's desktop. This error occurs (only occasionally) when he is creating a new entry into...

Is there a rows deactivate event? When my users insert a row, I want to prevent them from moving to another row until the cell in the column A of the newly inserted contains a value. Thanks

Hi All, I'm trying to get a macro working to generate new (empty) workbooks named based on text entries in column A. Each cell in column A should correspond to a newly generated (and named) workbook. The newly generated workbooks should be in csv format. Is there an easy way to do this? I've...

Hi: How does one create a name range that will be available to any worksheet or workbook or any newly created worksheet? I tried setting named range scope to “worksheet” but the name range is not available to another workbook or newly created worksheet. Could someone help please? Regards, Sean

Hi folks, I have a worksheet which contains data referencing different batches. The worksheet is password protected. I provide the user with a button to run a macro to add new columns (3 each time) to add new data for additional batches. I have conditional formatting on each of the columns which...

I'm trying to assign a VBA script in MS Outlook so that I can get all emails saved in a newly created folder (named by date, files also named by date). I create a folder and assign name to it: strNewFolderName = Format(dtDate , "yyyymmdd", vbUseSystemDayOfWeek, _ vbUseSystem) sName =...

Hi everyone, If we click the values from a pivot table, it will open a new sheet listing the data listed from the value, correct? Is there a way to apply conditional formatting to the newly opened sheet? What I like to happen is if a colleague double clicked the number of tickets assigned to...

I first Create Table (where the data is =$A:$B, incl headers). <tbody>#DAE7F5[/URL] "] A B C 1 Date Animal 2 11/01/17 Dog 3 11/02/17 Dog 4 11/03/17 Cat 5 11/04/17 Dog 6 11/05/17 Cat </tbody> Then, I create the Pivot Table. <tbody>#DAE7F5[/URL] "] D E F G H I 2 Count...

Hi guys After searching an hour for the correct code. I am creating a new shape with this code: Sheets("processtyring").Unprotect Password:="HKV" ActiveSheet.Shapes.AddChart(xlBarStacked, 150, 150, 1000, 250).Select Sheets("processtyring").Protect Password:="HKV" Now i...

Hi, I really hope someone here can help - I just signed up here to post an urgent question. I have been using Excel for decades but never went beyond recording macros so I don't know if there is a macro that you can write to allow me to do this - to insert the number of rows that I type at the...