#vba #excel #pleasehelp

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

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

Option Explicit Private Sub cmdSave_Click() Dim LR As Integer, Master As Worksheets Set Master = ThisWorkbook.Worksheets("Master") LR = Master.Cells(Rows.Count, "A").End(xlUp).Row If LR = 2 And Cells(LR, "A").Value = "" Then LR = LR Else LR = LR + 1 End If Master.Cells(LR...

Hi all! Basically like the title states, I need some help with writing a code that can 1. copy a range of rows that meets the criteria, and then 2. paste it into a range into another sheet. 1. In Sheet "Food Restrictions", there is table that ranges from B4:H1000 (1000 is a general...

how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink) This Invoice Product name Combo box with show Hyper link button appears Out side the combo box, how to possible pleased Need this vba code , (Condition : How to fix same place in range...

Need some help with a code that lets me clear contents for a cell that is over a year old, then also clears the contents on the remaining row until a certain point. The first cell in the row will have the date, and the next two cells will have data that needs to be cleared, adn the rest of the...

Hi guys, i need some help. maybe you can help. i have 4 sheets, first sheet as a Master Sheet. second until fourth sheet act as a slave sheet. Whenever there are any change in "sold" column in slave sheets, it will fill and affect the amount in "sold" 's column in Master Sheet based on criteria...

@ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

Hi guys! Hope you are all well! This is the first time I try this forum, so please do let me know if I didn't do something correctly. Also, I am a self taught VBA noob, so it would be greatly appreciated if you can please dumb it down as much as possible in the explanation/code. Thanks heaps...

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

hey Guys I am having issues with my code. Originally (see original code) I would loop through all sheets and combine data in to one. This worked great. Only 1 sheet had headers (data spill). 'Original code For i = 2 To Sheets.Count Set xRg = Sheets(1).UsedRange If i > 2 Then...

:)Hi All. This is my first post I am hoping a kind person can help me ... I have 2 worksheets in a workbook. Worksheet 1 "Prospects' - lists client records for potential clients. Worksheet 2 "Income" - an Excel table lists client records for actual clients. In the Prospects worksheet, I...

Having an issue trying to debug someone's work, don't know this style of coding well and so not sure what is wrong here exactly but the error it says is user-defined type not defined, and I tried fixing this by defining it as a different declaration and that didn't work. ' Connect to the...