vba & conditional formatting & protected worksheet

Ok, so I have a bunch of excel workbooks, located in SharePoint, that are full of lookups etc and I want to write a macro that I can place in each that will: Save the xlsm workbook before anything is done Remove any worksheet protection on all sheets (same passcode on all 9999) Copy everything...

Hi All, I have a spreadsheet that I need to split out a each unit and then password protect it. my spreadsheet will contain formatting and protected areas. I need to Retain all functionality in the split out files as well as update a master cell with the budget for that unit. I have some...

I have been trying to find a way to simplify this VBA code as it takes a little while to run currently. I want it to automatically unhide row 7 on sheet 07 through sheet 32 when cell J4 on the active sheet is higher than 0 and if it is 0 or less then hide the row on those sheets. then repeat for...

The below code works fine if the a single range is provided, example: =Macro1(A2:F2). But does not with multiple ranges, example: =Macro1(A2,C2, E2:G2) Is the a way around I could make it dynamic? Function Macro1(Rng As Range) If Application.WorksheetFunction.Sum(Rng) <> 0 Then...

I have created a VBA UDF to add 3 Color Scale formatting to a given range. The below code seems to be working when the value of Rng is hardcoded as "G5:J5" (with double quotes). Instead, I want it to use just G5:J5 so that I could drag it down. Can anyone please help? Function Macro1(Rng As...

When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table

Hello, the situation is that I have many shapes in 1 sheets 1. some shapes I want the user to be able to modify 2. some shapes I don't want the user to be able to do anything with it 3. I want the user to be able to insert new shapes as they wish Here is what I have tried so far Method 1: -...

Hi, I'm wonder if there is any way to code that After copy a cell value, then paste to Word and then enter the line and paste the next one? (can it be a loop?) My code right now is this. The <A1> in Word is formatted in numbering so when it pastes the value picked up from Excel, it will...

Hello! I'm quite new to the more advanced tools in Ecxel and I have never used VBA before, but I have some limited experience with programming in general. The worksheet is a calculator to help my colleagues calculate the prices of contracts before sending a quote to a customer. What I'm trying...

Hello, I was wondering if there is it possible to Link an IF condition with a cell color instead of a specific data using VBA. For example: A range of cells B4:B20 have data lets say numbers. some of those cells will change color to blue. for the sake of the example lets say B7 changed color...

Hello Again! I found an older thread with a similar question but I couldn't figure out how to apply it to my situation. On my [Sheet1] I have a drop down box setup that has 2 options (Inquiry/Update) what I would like to do is write a script that changes the workbook from read only to editable...

Hi guys am looking to code in a condictional formatting to a newly created sheet via vba This intales highlighting the row orange when you click on a cell between a certain range(Any range will do ill edit it to what i need) i would just set it up when i use it my self manually but unfortantly...

Current Issue: So far, however, I have (with assistance) created a user form in Excel that collects data and inputs it into a spreadsheet, which can then be exported to a PDF report using a set format/layout on another sheet of the workbook. The layout consists of a "Header" section and an...

When I run my macro based on conditional formatting, it just adds to the bottom when i need it to post in A8. (I highlighted the cells in yellow to show the duplication) C25

I am new to this and trying to get each row to automatically get copied to my second sheet "Completed", then deleted off my main sheet... So - when I select "completed" from the dropdown in Column "N", that entire corresponding row essentially moves over to the second sheet labeled "Completed"...

I'm attempting to protect the entire worksheet except for a set range for a series of worksheets that are identical. The workbook is comprised of time surveys for a number of cost centers. Each time survey is identical. However, I do not want them overriding some items and I don't want them to...

i need programe i have thousand of folder in my office pc i want to this folder uplode in excel sheet in a minute using vba code and this sheet i can use at home

I am attempting to use VBA to delete conditional formatting on a protected worksheet. When I run the simple macro below, I receive a 400 error. However, if I unprotect the worksheet, remove the lines of code for unprotect/protect, the macro works without error and removes all the conditional...