tricky form close

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waxaholic - 15 Mar 2007 03:06 GMT

I have a form (fmMover) which is used as input for Sheet1. I am trying
to lock it to this sheet only. If another sheet is selected, the form
should hide or close. Possibly minimize to the taskbar. I have tried
to use the fmMover.Close() in the Sheet1_DeActivate event but it won't
work. Does anyone have any advice or another approach to achieving
this.

Thanks,

Brian

Reply to this Message

Bryan Phillips - 15 Mar 2007 03:12 GMT

Try calling fmMover.Hide() instead.

--
Bryan Phillips
MCSD, MCDBA, MCSE
Blog: http://bphillips76.spaces.live.com

> I have a form (fmMover) which is used as input for Sheet1. I am trying
> to lock it to this sheet only. If another sheet is selected, the form
[quoted text clipped - 6 lines]
>
> Brian

Reply to this Message

Waxaholic - 15 Mar 2007 13:11 GMT

Thanks but it still persists. I have tried

fmMover.Close()
fmMover.Hide()
fmMover.Dispose()

yet the form just goes to the taskbar and remains.

On Mar 14, 8:12 pm, "Bryan Phillips"
<bphill...@nospam.spamcop.net.spammenot> wrote:

> Try calling fmMover.Hide() instead.
>
[quoted text clipped - 15 lines]
>
> - Show quoted text -

Reply to this Message

Bryan Phillips - 20 Mar 2007 17:49 GMT

Also, set the form's ShowInTaskbar property to False.

--
Bryan Phillips
MCSD, MCDBA, MCSE
Blog: http://bphillips76.spaces.live.com

> Thanks but it still persists. I have tried
>
[quoted text clipped - 25 lines]
> >
> > - Show quoted text -

Reply to this Message

tricky form close

Free Magazines