Tried to insert a Scroll bar and now my Columns go right to left

**Cidona** · 08-26-2010, 11:15 AM

Dear forum members,

While fumbling through the learning curve, I sometimes press things I shouldn't. In this case I was going to try insert a scroll bar from the Developers Tab (2007), which I admittaly know nothing about. However when I did it now has my columns reversed. I tried pressing undo but it will not undo past the inserion of the scroll bar. I have tried deleting the the scroll bar to no avail. I noticed that if I right click on the worksheet tab and select 'View Code' that there is an entry for 'Scroll Bar' in there. However not sure how to rectify and am a bit nervious as I know nothing about the Developer tab and didn't save prior to insertion.

Figuring it's not a good idea to have 'code' in there since I deleted the scroll bar, and don't know how to get my columns back to running left to right A, B, C... .
Any help would be great!
Thank you.

**MarvinP** · 08-26-2010, 11:30 AM

Is there any code between the lines Public Property Get ScrollBar and End Property?
You would see this from the developer tab and click on the sheet in the VBA Project window.

**shg** · 08-26-2010, 11:41 AM

See http://www.rondebruin.nl/sheetdirection.htm

**Cidona** · 08-26-2010, 11:47 AM

Hi MarvinP.

Thank you for your prompt reply. While looking for the Project window mentioned in your reply (found it

), I came accross the properties tab. Once I saw that, I remembered that I had adjusted the "Display Right to left" from False to True, thinking I was adjusting the direction of the scroll bar (experimenting here).
Think I better read a book before jumping into the Developer's tab again

Thank you again for you quick reply!