S
SmartyPants
I am running an access macro from an excel file and I want to stop
access from asking me whether I want to open the file or not.
Right now I press the button, Then it asks me to open or close
(access), if I press open - the macro runs and Access closes and
everything is ok, if I press anything else - I will get a runtime
error.
This wouldn't be a problem except that this sheet is designed for use
by the workforce at large, and it is impossible that every one of them
is going to press open.
I can't set macro security to low, it'll automatically change back.
Is there a way to set up this one database to be accepted
unconditionally?
access from asking me whether I want to open the file or not.
Right now I press the button, Then it asks me to open or close
(access), if I press open - the macro runs and Access closes and
everything is ok, if I press anything else - I will get a runtime
error.
This wouldn't be a problem except that this sheet is designed for use
by the workforce at large, and it is impossible that every one of them
is going to press open.
I can't set macro security to low, it'll automatically change back.
Is there a way to set up this one database to be accepted
unconditionally?