A possible idea:
I assume all activity is initiated in the workbook_open event. Have the
workbook_open event look at application.Path. If it doesn't match the
server, have it exit the sub. Or you might have a unique environment
variable on the server which you can check with the Environ function.

--
Regards,
Tom Ogilvy

ibeetb wrote in message
...
Sorry if I wasn't clear. Hope you will get this and I would have explained
it better.

I have an excel spreadhseet which I have run automatically at 11 PM every
night on a server. I want various users to view the spreadsheet - actually
they will NOT have to run it, because it runs and grabs its data at night,
by itslef-automatically.
What I need, is for the macros to NOT be enabled when they open it because
when macros are enabled and they open it, they get errors that they are
missing certain activex objects. So my real question I guess is....how can
I
diable the macros in code or what do I need to do in order that they may
open and view the sprdsht without getting the errors, yet I need to have
the
macros enabled during the night when the report runs on the server
automatically.....

Thanks


"Tom Ogilvy" wrote in message
...
Generally, excel runs locally - so they would access the file from a
drive
on the server and run it locally. In that case, the local machine would
need to have all referenced ActiveX objects.

It is unclear what you are proposing.

--
Regards,
Tom Ogilvy

ibeetb wrote in message
...
I have a couple of Excel spreadsheets that contain quite a bit of VBA
and
ActiveX objects. I want to put them on a shared server and have others
access them from the server. What do the users who will access this
need
to
have on their PCs? Do they need to have the activex objects on their
client
or does the server just need this?
Will the user just be able to open and run the report from their
client?

Thanks