Solved: How to make spreadsheet tabs invisible but not hidden

[kcscdf]

Hi, currently i am trying to make the spreadsheet tabs on my excel file invisible for clicking because i am using macro to link them up together. But, if i hide them my macro will not work. Hence, wish to ask if anyone knows how to deal with this problem? Usage of VBA are welcome too. Thanks a million...

[Bob Phillips]

Why won't your macro work if you hide them, I do that all the time?

[kcscdf]

oh because in my macro, in order to go to the spreadsheet, i involve a 'Sheets("whatever").Select' and if i hide and access my macro button, it gives me an error.

[Bob Phillips]

Then avoid the select and work direct on the worksheet object.

[kcscdf]

Anyway its solved... i found out that at option > view > sheet tab, you can make it not viewable.

Thanks anyway.

[Bob Phillips]

I don't know what you are saying there, but I re-iterate, you should not need to select the sheet.