Userform Issue

Hi,

Are you selecting or activating any cells on a hidden worksheet once
that userform is loaded?

Cheers
Andy

Bill wrote:
> Hello,
> I have several user form. With one, when it appears on the screen, you can
> select and move it around and have many, many images of it on the screen. I
> use the following for all forms:
>
> application.screenupdating = true
> load userform
> userform.show
> userform.hide
> unload userform
> application.screenupdating = false
>
> I thought the screenupdating = true would prevent that. Any ideas?
>
> Thanks,
>
> Bill
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Yes. Is that an issue?

"Andy Pope" <andy@andypope.info> wrote in message
news:unNTrHeHGHA.524@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Are you selecting or activating any cells on a hidden worksheet once that
> userform is loaded?
>
> Cheers
> Andy
>
> Bill wrote:
>> Hello,
>> I have several user form. With one, when it appears on the screen, you
>> can select and move it around and have many, many images of it on the
>> screen. I use the following for all forms:
>>
>> application.screenupdating = true
>> load userform
>> userform.show
>> userform.hide
>> unload userform
>> application.screenupdating = false
>>
>> I thought the screenupdating = true would prevent that. Any ideas?
>>
>> Thanks,
>>
>> Bill
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

Activating cells on a hidden sheet whilst the userform is displayed will
cause ghosting if you move the userform.

I suggest you confirm this by simply making the sheet visible and then
move your userform around. If the problem goes away you will need to
alter your code. You can still reference and use the cells on the hidden
sheet just not activate them. Most tasks do not require you to activate
the cells in order to manipulate them.

Cheers
Andy

Bill wrote:
> Yes. Is that an issue?
>
> "Andy Pope" <andy@andypope.info> wrote in message
> news:unNTrHeHGHA.524@TK2MSFTNGP09.phx.gbl...
>
>>Hi,
>>
>>Are you selecting or activating any cells on a hidden worksheet once that
>>userform is loaded?
>>
>>Cheers
>>Andy
>>
>>Bill wrote:
>>
>>>Hello,
>>>I have several user form. With one, when it appears on the screen, you
>>>can select and move it around and have many, many images of it on the
>>>screen. I use the following for all forms:
>>>
>>>application.screenupdating = true
>>>load userform
>>>userform.show
>>>userform.hide
>>>unload userform
>>>application.screenupdating = false
>>>
>>>I thought the screenupdating = true would prevent that. Any ideas?
>>>
>>>Thanks,
>>>
>>>Bill
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info