What is in AuditShtName? Sure it is not empty or a duplicate name?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
Please also note that I can Insert Worksheets manually. I
don't get it???


-----Original Message-----
I have a an macro that always works. It an addin which
creates an summary sheet in the active workbook. I just
ran it on a file and recieved this message:

Error 1004 Method 'Add'of Object Sheets failed

the line of code it is failing on is this:

.Worksheets.Add(After:=.Worksheets
(.Worksheets.Count)).Name = AuditShtName

Why would this be failing? Could this be a workbook
protection issue? When I go to Tools\Protection\ is does
not give the unprotect option.

THanks
.