activesheet.protect

Debugger brings me to this line below in red. My file activityreportdatabase.xlsx is in the correct location and is not opened. I can manually update link with this file but it goes to the debugger when I do it with this script. The cursor in the debug window in on the line with...

Below Macro is giving error message. Need urgent help.. Sub sbUnProtectSheet() ActiveSheet.Unprotect "9999" Set SourceRange = ActiveSheet.Range("B10:H10") Set FillRange = ActiveSheet.Range("B11:H39") SourceRange.AutoFill.FillRange Range("B11").Select ActiveSheet.Protect "9999"...

I ran a macro against a number of Excel workbooks to correct and error that I had found with some forms we use for recording time. The problem is that I put the incorrect syntax into the macro, strangely it still ran ? Syntax I should have used - ActiveSheet.Protect Password:="password" Here...

Hello all I am trying to protect part of my worksheet but still allow sort by filter but this line of code that I put together is not working out, any idea's please Rows("14:1048576").Select Selection.Locked = False Selection.FormulaHidden = False ActiveSheet.Protect...

Dear All, Following code is to highlight the Row in the given range when a cell is selected. This codes works perfectly alright until the time the workbook is Shared. "Application defined or Object defined error" is shown when the workbook is Shared. Private Sub Worksheet_SelectionChange(ByVal...

Hi I have the below sort which just uses I4:I28 etc as the asending sort what would below look like if I wanted to firstly sort F4:F28 in the order "Active then Inactive then extra" and then sort I4:I28 ascending for below rows Sub TestSort() ActiveSheet.Unprotect Range("4:28").Sort...

I'm using the code below, but keep getting the following error: Run-time error '1004' Private Sub CommandButton31_Click() ActiveSheet.Unprotect Password:="password1" Range("AA57:AA57").Select Range("AA57:AA57").Activate Selection.RowHeight = 12.75 Range("AA58:AA58").Select...