Run Time Error '1004':

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A spreadsheet that is used by many different people is coming up with the
subject error now which is defined as an "Application-defined or
Object-Defined error". It gives me the chance to end or debug. When I
choose debug it takes me to code that states:

Private Sub Workbook_Open()
Sheets("Olean - Wellsville").EnableAutoFilter = True
Sheets("Olean - Wellsville").Protect contents:=True,
userInterfaceOnly:=True
End Sub

The third line is the one that it is highlighted in Yellow. I'm not versed
in VBA so I have no idea what seems to be the issue but am guessing that
somehow the syntax has been altered. Based on this limited information I
have provided, are you able to help?
 
I should also mention that when I open the file [Group] is appended to the
file name. I don't have any idea what that means.
 
Carpie

The group mean that someone has clicked on another sheet while holding down
the Ctrl or Shift key. This 'groups' sheets so anything you do is 'mirrored'
on all the grouped sheets. To ungroup, right click on a selected tab and
select ungroup. Now save the workbook and all should be well when you
re-open

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top