i have VBA that runs a bunch of commands, and one of those commands is to run a macro with other commands- to export a table to a file and then to import another excel file to another table (i know it's cumbersome but it's the only way i know around a display issue and i'm still teaching myself this program).
the VBA is in the on-click event of a menu buttton in a form. this macro works perfectly fine when the navigation pane is showing, however when i hide the navigation pane (users should not have access to raw objects, they can get wherever they need via menus, buttons and macros on click and close events) the macro fails with error 2950 on my "output to" command, then on "stop all macros" button click gives me a 2046 runtime error: "the command or action '|' isn't available now."
and this is the only one of several macros that errors in the entire database. driving me absolutely batty.
i've tried searching the web but i'm getting a lot of info about the navigation pane that i don't need, and not any about it causing macros to fail simply by hiding. has anyone encountered this problem and if so, figured out how to fix it? i'm going to try to write the macro commands into VBA but i always have trouble figuring out the right commands and getting all the arguments written properly.
the VBA is in the on-click event of a menu buttton in a form. this macro works perfectly fine when the navigation pane is showing, however when i hide the navigation pane (users should not have access to raw objects, they can get wherever they need via menus, buttons and macros on click and close events) the macro fails with error 2950 on my "output to" command, then on "stop all macros" button click gives me a 2046 runtime error: "the command or action '|' isn't available now."
and this is the only one of several macros that errors in the entire database. driving me absolutely batty.
i've tried searching the web but i'm getting a lot of info about the navigation pane that i don't need, and not any about it causing macros to fail simply by hiding. has anyone encountered this problem and if so, figured out how to fix it? i'm going to try to write the macro commands into VBA but i always have trouble figuring out the right commands and getting all the arguments written properly.
