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.