Have the spreadsheet save a copy of the data in a separate file. If the
users just need the data and none of the code then no need for them to open
your workbook at all.

Tim


"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