Making an Excel tab – a worksheet – default open everytime for everybody in SharePoint.

I have a complex spreadsheet that I use to track security and accounts for Team Foundation Server. I created a worksheet that has a linkable index to all the other tabs. This sheet I named "Index"

The problem is the spreadsheet does not open on my Index tab, but whatever somebody opened and saved it as last time. I need the "Index" tab to be default.

Well, the problem is the order you create the tabs is the order they are named in the code of the Workbook. Renaming the tabs from Sheet1, Sheet2, etc. does not actually change the coded order.

Continue reading

Cover Art for Novel – This is my great design and it is very popular.

I used my Facebook friends to critique many different designs. I did all the work and this was the final design everybody chose. "Shocking Press Publications" is my publisher. At this time I'm justdoingKindle, but I was #85 for Spine Chilling Horror. Here is a large version of the Cover.