Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate fails when someone else is in the sheet
In my workbook open function (shown here), I activate my two tabs and call a
routine to do "ShowAllData" (they both use autofilter). Both sheets are protected w/password and the workbook itself has a password for opening. The sheet works fine for the first person that gets in, but when a second user tries to access the same workbook, they get an "Activate method failed, error 1004" on the first Activate statement. The error doesn't occur in all cases, this morning I went into a sheet that was locked by someone else, but didn't get the error, plus I haven't been able to recreate it with co-workers. Does anyone have ideas for why this could happen? Private Sub Workbook_Open() Dim MyDate MyDate = Date If MyDate #8/1/2005# Then Worksheets("NonExempt").Activate Call SetProtect Worksheets("Exempt").Activate Call SetProtect MsgBox ("Autofilter is available in this workbook. Feel free to set filters to allow viewing/printing of desired subsets of data.") End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code fails when sheet is protected | Excel Discussion (Misc queries) | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
MoveAfterReturn fails because sheet is protected | Excel Programming | |||
Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
Copy to another sheet fails | Excel Programming |