hide ribbon code error

[Jen0dorf]

Hi

my third foray into the Docmd region.

After browsing the web and help files I came up with the code to hide the ribbon. It seemed this was what the autoexec was made for so I added it to my autoexec file.

But to my total lack of surprise it failed to work telling me I had an end sub missing

Would appreciate someone taking a look

thanks



Ian

[ItsMe]

Is there any other code in that module?

There should at least be Option Compare Database at the top, in the header.

[CJ_London]

you have a function embedded in a sub

remove the function line and change the end function to end sub

[ItsMe]

you have a function embedded in a sub
...

HaHa I was staring straight at that and thinking, something doesn't look right.

[Jen0dorf]

Thanks for the assist

for some reason the runcode in the autoexec was not finding my function, Ieven typed the name in by hand.

Now for some reason it's now appeared in the drop down menu so all is working

cheers

Ian