Both answers were helpfull and very good, i did now explan myself good
enough. i have existing worksheets that i want to stay hidden, unless i need
them, when i input the number only the number of worksheets are opened at
that time.
Thanks

"Helpme" wrote:

I am trying to write a formula to open the amount of worksheets need when i
input a number.