is there a way to hide excell worksheet and only open user form?

**Jenkins27** · 02-28-2015, 06:44 PM

I want my userform named userform1 to be the only thing that pops up when the icon on my desktop is clicked.. I want the excel sheet to be hidden.. how can this be done?

**alansidman** · 02-28-2015, 08:33 PM

Look at this video. Change the macro to a Workbook_Open Event.

https://www.youtube.com/watch?v=3nlJuW0yK6U

**Jenkins27** · 02-28-2015, 10:08 PM

awesome!! thank you

is there a way to hide excell worksheet and only open user form?

LinkBack

Thread Tools

Rate This Thread

Display

is there a way to hide excell worksheet and only open user form?

Re: is there a way to hide excell worksheet and only open user form?

Re: is there a way to hide excell worksheet and only open user form?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel vba user form- open directly to user form not worksheet

make user form stay open while going to other pages but hide when i go to other sheet

[SOLVED] Resizing user form in excell

[SOLVED] Can i use lines in a user form in excell

Hide/Unhide worksheet on open based on user name

Bookmarks

Bookmarks

Posting Permissions