worksheet

Hello all, As the tile says, I need to share a worksheet but one sheet in the worksheet I need it to be private. Noone has access but me. Is this possible? Thank you !

Hi all, I have the below code which saves the current worksheet as a PDF file and then sends the worksheet out, but I would rather it send the PDF, can someone help? Thanks, Karl Dim OutApp As Object Dim OutMail As Object Dim saveLocation As String Set wb1 = ThisWorkbook saveLocation =...

Hi everyone. Good day. I am asking for a help regarding my simple problem that I didn't know how to work on. I have these excel file that change worksheet name depends on week. On this screenshot once I run the code it will change the first worksheet based on color (I didn't want it to based...

How can I reference a worksheet name from a cell found from a lookup function? For example, xlookup searches within worksheet 1, 2, and 3 for value. If value is found in worksheet 3, I want it to return "C", if value is found in worksheet 2, I want it to return "B" and so forth.

Hello helpful people! Here is my dilemma. I have a workbook that has a summary {Summary} page and ten worksheets {Employer #1, Employer #2, etc.} with specific data. Based on a Yes/No answer on the Employer sheets, I need data from two specific cells {B11 and F16} to transfer to a specific...

Hi So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them) I would like to be able to...

Hello I am new in Excel and I would thank a lot if someone can help me. I wrote this code with linked dropdown lists in cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$S$4" Then Range("$T$4").Value = Empty End If If Target.Address = "$S$5" Then...

Hi, I didn't do a search for this problem because I do not know how to make a correct search argument. That is all answers were about something else. This is the case. In my BeforeClose procedure I did a VeryHidden on all tabs and a show on a tab with a warning. The warning stated that the...

Hello all, its been a while. I have a function that counts the number of conditionally formatted cells in a row. When there's been little or no activity on the worksheet the cells holding the count results can be blank or show an error message when next you open the worksheet. I can double...

Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...

Hi Everyone,I followed a youtube tutorial to copy data from one sheet into another sheet in the same workbook. Mind you, I have no experience in VBA. Everything was working fine until I noticed that when i add a new entry it overwrites the previous row. I want the code to find the last empty row...

Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook. Then overwrite if sheet name exist. Example as follows: Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to...

Hi All, Kind of new to VBA, and have been studying previous posts I have 100s of worksheets with different ranges, but all need the same formulas applied to column A and B (if blank, preferably so that i can add and update the worksheets later). I can only get A2 to populate, any chance...

Hi people! The script that I've written reads the info on a column and if the value is zero, it highlights the value in red and copies the whole row to a new worksheet. The script works, but for some reason, it is also copying many other rows that do not fit the criteria. Anyone have a clue why...

Hi people, The code I currently have is fully functionning, however I would like to add a feature that takes each worksheet that starts with MW and makes it into a workbook that is then saved on a folder that I've made ( the path is C:\Users\(MYNAME)\Desktop\VBAWorkbookTest). Ideally, the...

Hello, I'm tryin to sort values based on colors, then on values The macro was working very well, but on one sheet, so I have to create a new module for each sheet, and because I have around 400 sheets, This is the simple working macro: Sub A_Sort() ' ' A_Sort Macro ' '...

I have a small table and some code which shouls extract the Generic Category value for each row and then use that Name value to greate new worksheets with. My table: and my code: Sub CommandButton1_Click() Dim cProduct As String Dim myRange As Range Dim sCell As Range Dim copySize As...

Hi, I have the following formula which is inserted on sheets through VBA code: =SUMPRODUCT((B3:AF3="AD")*(WEEKDAY(B2:AF2,2)<6)*(ISNA(MATCH(B2:AF2,HolidaySheet!A2:A3,0)))) The A2:A3 range contains two holiday dates which are on a separate worksheet. The holidays change depending on the year...

When I save this workbook under a different name and folder all the worksheets disappear how can I avoid this?? Private Sub BO_Report_Yrs() Dim dte As Date Dim numericalDate As Integer Dim sourceDir As String Dim year As Integer Dim Wb As Workbook Dim Folder_exists As...

Hello, A simple one. Private Sub Workbook_Open() Dim wsCSP As Worksheet Set wsCSP = Sheets("CSP Tracking") Application.ScreenUpdating = False With wsCSP.[A1].CurrentRegion .AutoFilter 10, "<" & [Today()]...