I have used the following code to open sheets displayed from a dropdown list.
I tried to modify the code to be able to close the sheet in the same manner but my very poor VBA skill leave me at a brick wall. I tried,
Please Login or Register to view this content.
but I am getting an error msg.Please Login or Register to view this content.
Jim O
Last edited by JO505; 09-14-2013 at 06:18 PM.
Hi,
Use this code to hide the worksheet:Hope this helpsPlease Login or Register to view this content.
ajryan88,
Thanks, that is just what I was looking for. I thought it would be something simple but with no real knowledge of code I was shooting in the dark.
Again, thank you for your time.
Jim O
can be a better option if users tend to mess around with the workbook.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks