Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run Time Error '1004'
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions |