password=password

Hello, I am looking to make a code work in the way that it finds the last available empty row in columns A to L since M will have data pull with a formula. But I am not sure how to or where to add the range to make it work. Can I please ave your help? Dim iRow As Long Dim ws As Worksheet Set...

Hello, I requested help a few month ago with this code, I was able to find a solution and customized like the following: Sub Externalabelshn() ' Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False...

Sub ResNoSort() lastRow = Cells(Rows.Count, 1).End(xlUp).Row - 1 ActiveSheet.Unprotect Password:="password" Rows("6:" & lastRow).Select ActiveSheet.Sort.SortFields.Clear ActiveSheet.Sort.SortFields.Add Key:=Range("B6:B" & lastRow) _ , SortOn:=xlSortOnValues...

Good afternoon - new here so please be gentle as i'm a total novice at VBA coding... I have a master spreadsheet that draws information from 3 password protected workbooks. In order to open then I have got the following code: Sub OpenSesame() Workbooks.Open Filename:="C:\folder\sub...

Hello All! I am having a tricky time figuring out why I am still getting a screen update in my VBA when I really do not want it. It will just freak out my users and lead to more questions. I have a toggle box switch in VBA that moves, changes colours and executes a sub based on the position...

I have written some code to make some columns visible based on a click of a button. I'd like to make it so when these columns appear (L & M) three other columns are hidden (I, J, and K). Any suggestions would be welcome. Thanks! Sub Hide() Sheets("Increase Program Workbook").Unprotect...

Hi, I am working on a macro that is supposed to refresh a pivottable in a protected worksheet. I put my macro bellow: Sub refresh() ' ' refresh Macro ' ' ActiveSheet.Unprotect Password:="password" Rows("4:6").Select Selection.EntireRow.Hidden = False...

Hello, I just need your help regarding my concerns too. I have a macro code that works in my laptop but not work in others laptop. I've instructed them to check these settings in their Trust Center.... Macro Settings - check-mark the "Enable All Macros" Macro Settings - check-mark the "Trust...

I have had this working well until it grew so large it runs for a long time. What I would like it to do is: Take the values on sheets (3_Create Scratch") range (I10:I109) and check for exact match on Sheets ("On Premise") range (A2:A10500) when an exact match is found remove the value from...

I have a macro written that will unhide the rows I want to be displayed on another sheet, but I cannot get it so that they will remain hidden when the checkbox is not clicked. Any help would be appreciated! I have it written two ways - can you tell me where I'm going wrong?! Sub...

I have used the form control checkbox in a shared workbook. The checkbox is on an 'input' sheet. When a macro on the 'input' sheet is run, the data is then copied to the bottom of the 'record' sheet then all unlocked cells and checkboxes are cleared so the 'input' sheet can be used again. It...

Hi, I have a worksheet which I protect with these settings. Select unlocked cells Use auto filter Use pivot table and pivot chart Once set, all works well, however.... I have a macro I use which expands or retracts the row heights in my table. When I run this I use this code. Sub...

Hello, I have a workbook with a a button, which I want to lock everything and delete the button. The following is the code: <code> Sub LockEverythingAndDeleteTheButton() Application.CutCopyMode = False 'clears clipboard ActiveSheet.Shapes.Range(Array("Rectangle 1")).Select 'selects export...