i have a worksheet and upon opening it a userform is loaded and ready to
use... is there a way when you double click the worksheet for the application
to actually be hidden aand just show the user form on the screen??
--
--Chip Smith--
i have a worksheet and upon opening it a userform is loaded and ready to
use... is there a way when you double click the worksheet for the application
to actually be hidden aand just show the user form on the screen??
--
--Chip Smith--
Try:
application.visible=false
and don't forget to set it back to True when you're finished with your
userform
HTH
--
AP
"Chip Smith" <ChipSmith@discussions.microsoft.com> a écrit dans le message
de news:B7335161-35E4-41BC-A8A6-056BE39CCFE1@microsoft.com...
> i have a worksheet and upon opening it a userform is loaded and ready to
> use... is there a way when you double click the worksheet for the
application
> to actually be hidden aand just show the user form on the screen??
> --
> --Chip Smith--
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks