Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error 1004
I have my workbook shared...and have been getting a Run
Time Error 1004. I've been trying to narrow down what is causing it in my code and it appears that it is something with the code below: Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub I understand sharing a workbook can make things a bit finicky...but what am I doing wrong here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004' | Excel Discussion (Misc queries) | |||
run time error 1004 | Excel Discussion (Misc queries) | |||
Run Time Error '1004' | Excel Discussion (Misc queries) | |||
Run time error 1004 | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |