Preventing new Workbooks

[JSussina]

I have an issue with new workbooks opening in a spreadsheet that I have created. I've done plenty of searching, and have only 1/2 solved the problem. I have found the following code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Which works perfectly, except for 1 problem. My office uses a sharepoint for verious projects, and when the sharepoint is loaded it forces itself into my file even though, per the coding above, it shouldn't. When this happens it interupts a piece of code that is looped and I get a debug error. Any help would be GREATLY appreciated.

 

[JSussina]

One thing I've discovered... The ignoreremoterequests works great for preventing workbooks from being opened into your file, but once you are in you can open new files, thus discrupting the code. This seems to be what the sharepoint is doing.. it is locating the invisible file, then making it active and then opens the new file in that instance. Is there a way to disable new/open workbooks in excel, so it is truly a stand-alone file?