issue with a userform not hiding, the commands are right though

here is the code table from userform6

'Control Budget" userform button

Please Login or Register  to view this content.

and here is the code for the COS button

Please Login or Register  to view this content.

here is the snippet of code from "Grand10"

Please Login or Register  to view this content.

if i turn off me.hide in my buttons then the userform does not close.

if i change the code above for this, then my error is "run time error 402 - must close or hide topmost modal form first"

Please Login or Register  to view this content.

i do have a userform4 that closes (runs before the above code) properly, so not sure what it is complaining about.

thoughts anyone?

cause its not hiding. let me upload a workbook with the code:

so i am attaching two workbooks. the parent (SheetsForConstructionAndImportingIntoViewpoint - FROZEN - for upload.xlsm) and the target workbook (Bay Main House CO6 - for upload.xlsx)

open up the parent, go to "navigation" sheet, click on "Import sheets"

from userform4, select "Navigate" and then click to the target workbook (where ever you saved it).

then userform6 opens (and never closes)

can you work with this?

yes a couple of lines before i show userform6. is that a problem?

i commented it out, doesnt appear to fix the issue though

thanks rorya, im pulling my hair out and i don't have much left.

i explicitly turned it on and reran the code. no luck.

so i finally figured it out. i replaced all the me.hide and userform#.hide with unload, like so:

Please Login or Register  to view this content.

that made the code work. don't know why though.

thoughts?