Run Time Error 1004 Vba. Programmatic access to visual basic project is not trusted mean. The error is known to be most prevalent on excel 2003 and excel 2007 although no version of microsoft s popular worksheet application for computers is safe from the menace that is run time error 1004.
Using the developer tab in ms excel. Run time error 1004 is an error code pertaining to microsoft visual basic that has been known to affect microsoft excel users. This error is caused by a security option in excel meant to deliberately lock out programmatic access to microsoft visual basic for applications vba unless a user chooses to permit such access.
What is runtime error 1004 in vba excel.
By creating a new excel template. Open the excel sheet with which you are facing the issue and. Vba runtime error 1004 example 5 go to the developer tab click on visual basic to open vb editor. Declare a sub function to start writing the code.
