Tabs on Worksheets

**allipops** · 09-26-2007, 03:57 AM

Does anyone know whether it is posible to resize the tabs at the bottom of the worksheets?

I am trying to make them bigger so they are more obvious.

**VBA Noob** · 09-26-2007, 04:01 AM

See link

http://j-walk.com/ss/excel/usertips/tip021.htm

More helpful links below

VBA Noob

**allipops** · 09-26-2007, 04:32 AM

Thank you for that, but it doesnt achieve what I am trying to do. I currently have a website in which people open an excel document. So I want the tabs bigger no matter who opens it and no matter what machine it is opened on. Many of the people who will look at the document are not computer literate and do see that there is more than 1 sheet available hence my reason for wanting to enlarge the tabs.

**VBA Noob** · 09-26-2007, 05:07 AM

Not sure it can be done then.

Could you add a worksheet event macro so when they open the file it gives them a message that it has more than one sheet ??

VBA Noob

**allipops** · 09-26-2007, 06:11 AM

Thank you. I have no idea how to do macros......but I know someone who does so I will get them to do that for me.

Thanks for your help.

**VBA Noob** · 09-26-2007, 06:17 AM

An example for you

Please Login or Register  to view this content.

Link shows you were to add

http://www.contextures.com/xlvba01.html#Workbook

VBA Noob

**allipops** · 09-26-2007, 08:40 AM

I am not experienced enough to do complicated things, so I was wondering whether there are instructions on this forum on how to add a button which takes the user to the next sheet.
Thanks.

**VBA Noob** · 09-26-2007, 08:43 AM

Maybe you could download this add-in (Worksheet Navigator Toolbar)

http://www.contextures.com/excelfiles.html#UserForm

Then copy the code into a normal module

VBA Noob