PDA

View Full Version : Solved: How to make spreadsheet tabs invisible but not hidden



kcscdf
03-23-2009, 12:42 AM
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
03-23-2009, 12:46 AM
Why won't your macro work if you hide them, I do that all the time?

kcscdf
03-23-2009, 12:48 AM
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
03-23-2009, 12:52 AM
Then avoid the select and work direct on the worksheet object.

kcscdf
03-23-2009, 12:53 AM
Anyway its solved... i found out that at option > view > sheet tab, you can make it not viewable.

Thanks anyway.

Bob Phillips
03-23-2009, 01:24 AM
I don't know what you are saying there, but I re-iterate, you should not need to select the sheet.