Recent content by Gwolfe7

Okay, that makes sense. I appreciate the confirmation. I'll let you know if my test user was successful. Regards,

Thanks for your message however none of my files have that option (screen capture attached). Are you saying the user I sent this to should check the unblock checkbox?

I have a sheet with checkboxes/buttons that run Macros. Is there a way to code to enable macros in the background & then reset them when Excel is closed? My users would not understand going thru Trust Settings, enabling Macros, etc. I’ve spent hours building this workbook as a beginner & now it...

YOU! are the man...That worked perfectly. Thanks again!!!

Good Day! I'm back again. Can you tell I'm a newbie to Excel? The last code provided works well to change the cell background/font color however I'd like to see the full string from the Sy's Choices sheet. I've attached my code & screen captures. A full text from the sheet I'm copying it from...

If I’d like to copy the formatting (cell color=RBG #7B240B/font color=white) of Interface3 to ws2 (named Summary) what and where might I insert the coding? Would it be right after ws2.Range("A:A").Clear ?

This seemed to work when added to your 2nd code suggestion after Next cell. Sheets("Summary").Activate Thanks for your review!

May I please ask for one other function??? While using the "Move" button on your 1st reply (I created a button that says "Click for a Summary"). I'd like that click to open Sheet3 to review the items moved to that sheet. Thanks again!

This worked perfectly. Again, thanks for your time & subsequent review. With warm regards...

Dear Aniruddah, I tried the code after thanking you but I'm receiving an error upon trying to run it. Does "I" need to be defined as a variable? I have made some slight changes to the Sheet names and ranges (was using G rather than H for the helper column.) I have attached the error message. Thanks

This is excellent, thanks again for your reply & code. I appreciate your mention of replying again with any questions. With warm regards...

I have checkboxes in range(G8:G47) that returns a TRUE value if checked & changes the fill color and font to Bold in range(B8:B47) of the text within that range. If the checkbox is checked I’d like to move the text in B8:B47 to sheet2 starting at A1 down to A47. I’d also like to delete the...