password=

Hi folks, For a worksheet I'm making a comment form. What it does is simply add some text to a cell the user selects. What I've been unable to figure out is how I make only the added text in red, while the rest stays the same (black). Right now it add's the text from a Textbox to a cell. It...

I used this same code in another worksheet but with different ranges without issue. Now when I run the same code it causes the first cell under QTY to become a table. Any idea what would cause this? I did find if I rem out " srcWS.Range("AD4:AD52").AutoFilter Field:=1, Criteria1:="<>" "...

Hi, I'm a bit of a novice when VBA and have tried a macro that removes a password from a locked excel sheet, does an action and locks the sheet again with the password. I seem to be unable to enable filtering and sorting, getting the error message "expected named parameter". Is anyone able to...

I have the following code that won't work. Ideally, I would like for any cell in column Q in the chart to toggle values from "" to "P" upon selection. Also I need Range("L5") to toggle 5 different values upon selection Please see code below. Private Sub Worksheet_SelectionChange(ByVal Target...

Hi all. The code bellow seems to be working randomly. Private Sub Worksheet_Activate() Sheets("customers").Unprotect Password:="******" 'UnProtects the customers sheet. Columns("A:R").Select ActiveWindow.Zoom = True Range("F14").Select...

Hi I am having problems inserting Hyperlinks in unlocked cells on protected worksheets. With the help of this forum I have been successfully using the code below to auto filter However, I have noticed after this code is run, I am unable to insert a hyperlink in the unlocked cells. I have...

I have some vba code to protect and unprotect the sheets in my workbook. This code runs fine (IE as expected) on Excel for Windows 2007, 2010 and Excel for MAC 2011 but in Excel for Windows 2019 it switches sheets when run. The Workbook has 6 sheets and the code below runs from a button on...

Hi I have the following macro and I need to tidy up and make a few changes if poss. What it is when it opens up X/BACKUP I need it to auto create a subfolder and then ask me to name it before moving the data from the other files into it. Macro enclosed. ActiveWorkbook.SaveAs...

I have a form with two buttons. "Add Page" "Print" When I add the fourth page and print the heading from the third page lands near the bottom of the second page. The print range appears to grow as pages are added. I am using the following print macro. Sub Set_Print_Area() 'Unprotect Worksheet...

Dear All, Following code is to highlight the Row in the given range when a cell is selected. This codes works perfectly alright until the time the workbook is Shared. "Application defined or Object defined error" is shown when the workbook is Shared. Private Sub Worksheet_SelectionChange(ByVal...

Hi, All I have a macro that will send an email when it is triggered...But it will only send if my outlook is open. Is there a way to make this work without having to open my email first? Here is the macro I have. Sub Button7_Click() Worksheets("Tracker").Unprotect Password:=""...

I have a VBA code to save as my file in other location but I need an improvement to save as my file without dialog prompt ActiveWorkbook.SaveAs Filename:="C:\Users\alex-cccp\Desktop" & ActiveWorkbook.Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _...

Hello, I got several Excel spreadsheets running with VBA scripts. Thank you all for helping me with those. Now I wonder one thing. In a module several individual scripts are listed. All include password protect / unprotect. If I want to change password I have to change them all in all modules...