Hello all, new to VBA I have a useform in my project. When I run my macro it runs the userform but cannot click on any worksheets within the workbook. Ideally I would want the userform above every worksheet within the workbook. And will like to be able to use the sheets below it. Any help will be much appreciated.
Last edited by royjones86; 05-12-2011 at 05:28 AM.
Hello royjones86,
Welcome to the Forum!
You need to change the property ShowModal of the UserForm to False. Then you will be able to use the worksheets.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks for the help Ross, exactly what I wanted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks