I
ibeetb
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
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