I have a Userform where some Commandbuttons are made Visible=False during the
process. But when I want to preview my underlying document I have to Hide the
Userform. After closing the Preview and returning to the Userform, the
CommandButtons becomes visible again.
Is there any neat way to check the state of the buttons before the preview
and return to that state when the Userform is displayed again? I can of
course go through button by button and set a variable and go through it again
and reset to initial state when redisplaying the Userform, but it seems to be
a dull and sluggish solution.

They should be hidden when shown later.

Are you sure you hide it and show it, not Unload and Load?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mats Samson" <(E-Mail Removed)> wrote in message
news:691D8B33-2E80-4BCC-B881-(E-Mail Removed)...
> I have a Userform where some Commandbuttons are made Visible=False during
the
> process. But when I want to preview my underlying document I have to Hide
the
> Userform. After closing the Preview and returning to the Userform, the
> CommandButtons becomes visible again.
> Is there any neat way to check the state of the buttons before the preview
> and return to that state when the Userform is displayed again? I can of
> course go through button by button and set a variable and go through it
again
> and reset to initial state when redisplaying the Userform, but it seems to
be
> a dull and sluggish solution.
>

No Bob, it's only Hidden but I think I found the fault.
The Visible=False instruction was issued in another and Private procedure
and most probably it didn't retain the values when the Userform was hidden
and shown again.
It works though doing other stuff like changing page in the multipage form
and back again.
Thanks anyway

"Bob Phillips" wrote:

> They should be hidden when shown later.
>
> Are you sure you hide it and show it, not Unload and Load?
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Mats Samson" <(E-Mail Removed)> wrote in message
> news:691D8B33-2E80-4BCC-B881-(E-Mail Removed)...
> > I have a Userform where some Commandbuttons are made Visible=False during
> the
> > process. But when I want to preview my underlying document I have to Hide
> the
> > Userform. After closing the Preview and returning to the Userform, the
> > CommandButtons becomes visible again.
> > Is there any neat way to check the state of the buttons before the preview
> > and return to that state when the Userform is displayed again? I can of
> > course go through button by button and set a variable and go through it
> again
> > and reset to initial state when redisplaying the Userform, but it seems to
> be
> > a dull and sluggish solution.
> >
>
>
>