1. K

    Add text in red with userForm

    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...
  2. E

    VBA code converting cell to Table

    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:="<>" "...
  3. A

    Error message: "expected named parameter" when using AllowFiltering:=True

    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...
  4. P

    Cell change by selection Error

    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...
  5. albertc30

    activate sheet not always calling for form...

    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...
  6. D

    Hyperlinks in unprotected cells in Protected Worksheets using VBA

    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...
  7. R

    VBA switches sheets running in excel 2019 v 2010+2007+2011 for MAC, where it does not

    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...
  8. G

    Need assistance in cleaning up a macro

    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...
  9. lmmay

    Page overflow when printing

    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...
  10. K

    row highlight code doesnt work in Shared WorkBook

    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...
  11. L

    email macro

    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:=""...
  12. H

    macro to save as without dialog prompt

    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 _...
  13. H

    Reduction of passwords

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back