sh.name

The following macro is designed to split several tabs within a sheet into individual files. What I would like to do is get this part of the macro: Format(Date, " BOB mm-yyyy" to prompt a dialog box once at the beginning of the macro to ask what is the additional name tag the files should use...

Hi all I have code below work well but I want to change this line: <code style="box-sizing: border-box; font-family: inherit; font-size: 1em;">If Sh.Name <> "LocKH" And Sh.Name <> "Ma" Then to <code style="box-sizing: border-box; font-family: inherit; font-size: 1em;">If Sh.Name =...

Good morning, I have a spreadsheet with 5 or more sheets and I am trying to create code that will loop through sheets and copy the same range from each sheet to the "Overall Summary" sheet. The range should be copied into the next blank row. Here is the code I have so far, please help. Thank...

Good day Team, This macro works fine except I need to isolate it to a non-contiguous range of cells (commented out I the code:) Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) 'Inserts a comment box if the cell value is less than 99%...

I have created a macro that creates several different worksheets. I'm using the code below to output each of these newly-created sheets to a .PDF which is then stored in the same folder as the workbook. I'd like to move these new sheets to a new folder created by VBA. This is payroll data...

Hi I want users to be able to click on a worksheet and then be prompted to enter a password before they can view it. I found this on another thread but a row of code is highlighted in red and it doesn't seem to work. I get Compile Error Syntax Error. Public PvSh As String Public Pwd As...

Hi folks, Situation: I have a specific range---$F$7:$F$13---that I need to copy from all worksheets except two worksheets: sh.name "MACRO" and sh.name "ExtraData". As I don't know how many worksheets I might have to copy $F$7:$F$13 from, I found this macro to faciliate the copy/paste. Public...

Hi All, I'm working with an xlsm parent document where the sheet's tab names changes in producing a new children workbook. My question is is there a way to generically assign a sheet name according to its assigned worksheet#/sheet# in the code below, so I can avoid using over a hundred sheet...

Hi everyone, I'm new at this. I copied the below code from one of the thread. It works perfectly but I want to make it loop until I decide to cancel it. Thanks in advance. Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim sh1 As Worksheet, sh2 As Worksheet Set sh1 =...

Hi, I have a workbook that has sheets called week 1 through to 52 and a sheet called dump. I need to automatically hide from a workbook_open, every sheet BUT the "Dump" and "Week " & X where X is current week number and then the next 3 weeks. For some reason, the code I've created doesn't...

I'm looking for some help converting code from array to non-array. I was using Lbound to Ubound with the array. Can you please help adjust this code so that it works in this new format? Thanks for your help with this. If sh.Name = "Closer" Or sh.Name = "Mario" Or sh.Name Like "Fin*" Then...