• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tabbed Workbook Browsing within Excel - a la Firefox - using VBA?

A

alexsheehan

Member
Hi folks


Does anyone know if it is possible to create a tabbed browsing interface for workbooks within Excel VBA? There are some add-ins available online which are (as far as I can tell) all 'pay-for' items but I was just wondering if this feature would be achievable in VBA?


Most of the ones I have seen are all installers and I am unable to install on the work PC, hence the need to try and find a VBA solution/add-in maybe?


Cheers folks


Alex
 
Alex


You may want to read this:

http://www.mrexcel.com/forum/excel-questions/557959-visual-basic-applications-tabbed-browsing.html


or have you had a look at:

http://www.filecluster.com/Business-Office/Office-Suites-Tools/Download-Workbook-Tabs-for-Excel.html
 
Thanks Hui!


I haven't looked into the first item you mention in too much detail, but as far as I can tell, this is not really what I am looking for as it is pulling data from webpages into a single workbook, rather than opening up several windows for each page (please correct me if I misunderstand).


The second item is actually one I have looked into, and is exactly what I want, unfortunately;-


a. I preferably don't want to pay for it.

b. I don't have the Admin privileges to be able to install software on my machine.


However, I can access VBA and was wondering if there was an add-in/VBA code out there somewhere already that achieved exactly what the second item does, or if anyone with more talent than I (most of the population then!) had any clue how to accomplish this in VBA manually.


If I have to, I may have to cave and ask IT if they can allow me to install this software on my machine (quoting benefits, grovelling and sniveling to the IT gods), but I want to try to explore free/manual/non-installer methods first.


Thanks very much for your help.


Alex
 
I am also interested in this functionality. I've tried to install Tabs for Excel over at http://www.extendoffice.com/product/excel-workbooks-tabs.html but once again, I have no admin rights to my machine so no luck.
 
@All

Hi!

If had installed the product from 2nd link and after uninstall you find that if opening more than one workbook and having set windows task bar to never combine buttons, it doesn't show an icon per file but just an unique Excel icon, then do this:

Excel, File, Options, Advanced, Show section, click on "Show all windows in task bar", Accept.

Regards!
 
You must log in or register to reply here.
Back
Top