tesla764
asked on
Excel - Hide a tab in the workbook without hiding the functionality.
Hide a tab in the workbook without hiding the functionality.
When I hide the tab called "Country Category Table" then run the program i get...
Error: Select method of Worksheet class failed.
Is there a way to keep all the functionality and just not have the tab "Country Category Table" appear?
Thanks in advance for your help.
When I hide the tab called "Country Category Table" then run the program i get...
Error: Select method of Worksheet class failed.
Is there a way to keep all the functionality and just not have the tab "Country Category Table" appear?
Thanks in advance for your help.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What i meant is
you should get rid of the select like that
you should get rid of the select like that
Worksheets("Test3").Range("A1").Value = 1
instead of Worksheets("Test3").Select
Range("A1").Value = 1
Regards
ASKER
I will give that a try. It may have to wait until Monday. It's getting late in the day and I have a few other things to do before I go today. I will let you know.
Thanks.
Thanks.
ASKER
I will be able to try this on Monday.
Thanks and have a great weekend.
Thanks and have a great weekend.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER