As far as I can see in your code, you've never set the wksMacRec
variable. You need some code like
Dim wksMacRec As Worksheet
Set wksMacRec = Worksheets("Sheet1")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"davegb" wrote in message
ups.com...
This code is on the worksheet module. It hides the commandbar
that is
unique to this sheet when the sheet is deactivated and erases
the
commandbar name from the worksheet so that XL doesn't try to
hide the
toolbar when the workbook is closed.
Private Sub Worksheet_deActivate()
Application.CommandBars("Abuse").Visible = False
With wksMacRec
.Unprotect Password:=PWORD<----ERROR
.Range("E2").Value = ""
.Protect Password:=PWORD
End With
'ActiveWorkbook.Worksheets("Macro Records").Range("E2").Value =
""
End Sub
I'm getting an "object variable or with block variable not set"
error.
The password in set as a public constant in another module in
this same
workbook. So whatzzup?
Thanks as always.