Macros disabled by hiding shutterbar

[SemiAuto40]

This is driving me nuts I use VBA in User Login to set access level and to hide the left side "shutterbar" and ribbon bars too - so that some users are limited to only do what won't confuse them or allow them to do dammage.



When I place this line: DoCmd.SelectObject acTable,, True
in the login I see the shutterbar (navigation pane) which is great..... but when I comment it out so that the shutterbar (navigation pane) disappears (like I want) THEN a macro inside the app throws an error that the macro is not available, of something to that effect.

What do I need to do to hide nagivation pane yet still be able to use macros in my app???

Thank you for anyone taking time to inform me.

[June7]

Why are you selecting table?

Is it a data macro? I don't use macros, only VBA, unless absolutely no way VBA can do it. I have resorted to macros twice.

[SemiAuto40]

The macro action is printing a table converted into HTML for easy browser viewing. Maybe I should see if the macro could be converted to VBA. Problem is still that hiding the table the way I do discombubulates the macro.

[June7]

I don't understand why hiding the Navigation pane causes hiccup with macro, never had reason to explore this. I do know that hidden Navigation pane has never been an issue with VBA. It is possible the issue is with the SelectObject method and even VBA could have problem. I have never used SelectObject. You could convert macro to VBA and see if the issue persists.

Post your code and/or the project for analysis.

[SemiAuto40]

The actual error is "output to is not available now". Only happens when the line DoCmd.SelectObject acTable,, True is commented out.

[June7]

Oh, I misread OP. The SelectObject line makes the Navigation pane visible then the macro runs okay? Could be the only alternative is to open the table with .OpenTable (with macro or VBA). The navigation pane will remain hidden.