form locking out other sheets

[synergy16]

good morning all. im having an issue that when a user opens a form taht i made based on VBA code, it locks them out from access to any other non-related excel sheets. is there a fix for this?

 

[Fluff]

I asked if you had any other code in the Initialize, or Activate events, in-case there was something there that was setting the form back to Modal.
But as you can interact with some other sheets/workbooks, that would not seem to be the case.

 

[synergy16]

I asked if you had any other code in the Initialize, or Activate events, in-case there was something there that was setting the form back to Modal.
But as you can interact with some other sheets/workbooks, that would not seem to be the case.

ahhhhhhhhh, what YOU said was redundant and you edited it. got ya, lol, i thought you were saying the extra info i gave was redundant. and ya, its very weird how its acting.

 

[jmacleary]

Hi synergy

First, thanks for the thanks. In post #6 you show a Userform_Initialize routine. If this is being triggered by a show statement somewhere, make sure that that show statement has (0) on it as well.
In relation to post #7 ,

i can access another excel sheet if i open a new excel file from the windows search bar function

What is happening here is that Windows is creating a whole new instance of the excel application. The scope of any application based things (such as modal/non-modal forms, automatic v manual calculation) is limited to each excel instance. So when you open via the search bar function you get a second excel.

 

[synergy16]

ya, thats what i figured with the second instance of excel but i would still like to not have to have the user need to do that.

First, thanks for the thanks. In post #6 you show a Userform_Initialize routine. If this is being triggered by a show statement somewhere, make sure that that show statement has (0) on it as well.

can you expand on this a little more? where exactly should the "show statement" be? what sub routine?

 

[Jon Peltier]

A quick note to satisfy my OCD.

Instead of

.Show (0)

you should use

.Show vbModeless

It is easier to read later, when you've forgotten what 0 means in this context.

Also, no need for the parentheses around the argument, even if you don't change to the vb constant vbModeless.