I have a couple of spreadsheets that run automatically on a server and
various users open them just to view. Problem is.....when they click Enable
Macros, they don't have the ActiveX controls on the spreadsheet on their
local machine so they receive an error. Microsoft doesn't allow you to
disable macros in code for obvious security reasons but does anyone have any
ideas - short of just telling the users to DISABLE MACROS at workbook open
or installing the controls on their machines - to not make the macros
enabled or prevent them from gettin this error?

Thank you

If you only need the macros for your automatic updating, why not
remove the macros from the workbook and place them in a separate
addin?

Paul

------------------------------------------------------------------------------------------------------

I have a couple of spreadsheets that run automatically on a server and
various users open them just to view. Problem is.....when they click Enable
Macros, they don't have the ActiveX controls on the spreadsheet on their
local machine so they receive an error. Microsoft doesn't allow you to
disable macros in code for obvious security reasons but does anyone have any
ideas - short of just telling the users to DISABLE MACROS at workbook open
or installing the controls on their machines - to not make the macros
enabled or prevent them from gettin this error?

Thank you