Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

open spreadsheet to a specific tab

hi,

i'm certain there is some code / vb function that that can be used to program a spreadsheet, to open on a specifc tab.

however, i can't for the life of me figure it out.

the tab name = "Welcome"

any idea's ppl?

thank you v.much.


Post your answer or comment

comments powered by Disqus
Is there a way to make a link to a specific tab in excel? I have a workbook
with many tabs and I want to make an first page that has links to go to
specific tab when clicked.

I'm using the following code to assign keyboard shortcuts:

Sub assign_shortcut_keys()
    Application.OnKey "^1", "sub_to_run"    
End Sub
It works, but it assigns a shortcut that also remains active when I go into another tab of the worksheet or if I go to a different worksheet....

How can I assign shortcuts only to a specific tab within a worksheet?

Thank you.

I have an MS Access database that points to a specific Excel file that has 10 spreadsheets. Is there any way to address the file so that it will open a specific tab? My filename is D:budgetmonthly_report.xls (this file has multiple tabs Jan, Feb, etc..) Can you address the file name with month name so that specific tab is what opens?

Thanks for any help. Paul

Can anyone tell me how to save an excel file so that it always opens to a
specific tab and cell regardless of where the cursor was the last time the
file was saved?

Is there a way that when I open my workbook that Excel can go to a specific worksheet, so it is the one that is displayed when I open the workbook?

Can this be done via a setting in Excel, or a macro that is executed when Excel starts the workbook & switches to the worksheet I want to see when it starts up?

If it can be done via a macro, how do I connect the macro to run when I open the workbook?

I can easily link from Excel to a PowerPoint file, but how can I make it go
to a specific slide within that file/presentation?

Thanks,
Charlie in Virginia Beach

hi, i'm trying to find a way to prefix a macro i have so that when it is run it will only apply to a certain tab within a worksheet. currently, when run it will apply to the current tab i am in when i run it..

I would like to have a specific record displayed on my form when I open it. The record would actualy be an Id # for the infomation. In the forms property window I assume that the event procendure would be written in the "on open " on the event tab. I am not sure of what the code would be. any help would be greatly appreciated.

Thank you

Tim

Need to SEND data from userform to a "specific row" within a speadsheet table.....based upon the criteria selected by the user within the user form.

Example: User selects "2005" from the year drop down box..... and "OCT" from the month drop down box....then enters all their month-end metrics. User hits SUBMIT (sending it to the database/master holding tank -which is simply a spreadsheet )...ready for chart generation....

Right now, my code sends the metrics to the spreadsheet, but goes to the first available row.... (this is bad for several reasons in our case)

I need it to find the row that has: "2005" (col A) and "OCT" (col B) then, LAY IN THE DATA starting at column C....once it has found the appropriate row to lay the data into.....
(see attached image).....data should go to row 14...then lay in starting at Col C....within all the defined cells to the right.........

I've shared this with a lot of people this month looking for a way...but noone seems to know the answer...
Does anyone know how to alter the below code to make it do the above?


	VB:
	
 cmdCancel_Click() 
     'when the user clicks cancel it will close out the form
    frmRGUserEntry.Hide 
End Sub 
 
Private Sub cmdSave_Click() 
    frmRGUserEntry.Hide 
    Dim MetricOut As Range 
     
     'get to the end of the list so you can begin population
    Set MetricOut = Worksheets("UFDATA").Range("C65536").End(xlUp).Offset(1, 0) 
     
     'whatevers in text box 1 put into location 0,0 etc
    With MetricOut 
         'CYCLE TIME
        .Offset(0, 0) = TextBox1.Text 'column C
        .Offset(0, 3) = TextBox2.Text 'column F
         'EFFICIENCY
        .Offset(0, 9) = TextBox3.Text 'column L
        .Offset(0, 10) = TextBox4.Text 'etc.
         'TIMELINESS
        .Offset(0, 18) = TextBox5.Text 
        .Offset(0, 19) = TextBox6.Text 
         'QUALITY
         '  no input from user needed in this category
         'ACTIVITY
        .Offset(0, 37) = TextBox10.Text 
        .Offset(0, 38) = TextBox9.Text 
        .Offset(0, 39) = TextBox12.Text 
        .Offset(0, 40) = TextBox11.Text 
         
        .Offset(0, -2) = cboYear.Text 
        .Offset(0, -1) = cboMonth.Text 
    End With 
     
     'now immediately open the next CNA form
    frmRGCNA.Show 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I GREATLY appreciate any guidance you can provide

hi all,

i've got a nasty problem which might be incredibly easy, or impossible....its definitely got me stumped anyway.

the problem is this...i've got an excel workbook called..lets say.. "Database"..it contains spreadsheets with lots of exciting data..and Users view(and occassionally add to) this data through a variety of userforms.

what i'd love to know is whether theres any way to "bind" userforms to a specific workbook?
i.e. can i make it so my userforms "MIGHT" be displayed (might bcos it depends on the users selection)...while "Database is the active worksheet".....but not displayed if it isn't...e.g. if they open another excel workbook..

at the moment my userforms are present in every excel project (while Database is open and the forms are being used), which is clearly bad since they block half the screen....

does anyone possibly know how to have Userforms only show up when a specific workbook is being used??????i've been stuck on this for a couple of days now and its driving me crazy.

equally if you don't think its possible, i'd love to know so i can stop wasting my time on this....there is a way around the problem..but it involves putting my "Main Menu" -which opens all my userforms- as part of an excel spreadsheet instead of a userform..and having it userform based just makes it look so much better.

hope that was a clear enough explanation, and that one of you takes pity on a poor newbie who might just go insane otherwise.

Cheers,
Tristan

Hi, I know how to make links to another spreadsheet. I also know how to create a link to another workbook, but how do you make a link to a specific spreadsheet in another workbook? Fo example I want to click on the name of a sales person in my data workbook, and I want it to bring me to the spreadsheet of that person's sales in my sales workbook. The sales workbook has a different spreadsheet for each sales person.

Can you open a Usefrom that has a MultiPage and go to a specified tab using a Macro/Code?

Thanks
Greg

I set up a work book with ~10 worksheets in it some time ago and made it open to a specific sheet. So no matter which sheet you saved it on the last time, it would still open the file to a certain sheet.

Unfortunately I cannot remember how I did it. There may be several ways but can anyone help out.

I can get a hyperlink to open a specific workbook from another workbook, but can the hyperlink be used so that when the workbook opens via the click of the hyperlink, it automatically opens to a specific cell on a specific worksheet?

For example in cell A1, on sheet1, in workbook test1.xls, there's a hyperlink/formula to open a workbook called test5.xls on sheet3 cell A5...without using any kind of VB/macro code.

I need to know how to modify an excel shortcut to make a file always open to
a specific named "intro" sheet.

s am using the following script to make excel open to a specific worksheet:
Sub WorkBook_Open()
Worksheets("Intro").Activate
End Sub

When A user used the intro sheet, I have a macro that then changes the name
of the file to a user inputted name and then goes to a "table of contents"
worksheet.

I need to write another macro that will then make the file that is now saved
under a different name to open to the "table of contents" worksheet and not
the "intro" worksheet when it is opened a second or successive times.

Does anyone know how to do this. Assume I don't know anything when wording
any answers.

can anyone tell me how to set excel to open to a specific folder

I know how to set Word 2007 to always go to a specific folder when clicking
on Open. However, I can not firgure out how this is done in Excel 2007.

Hello! Thank you all who answered my question yesterday. I really
appreicated your suggestions.

The next question I have is how to move a macro out of my 'Personal'
excel worksheet (stored on my local desktop) to a specific worksheet
that can be on the network for others to use? Also this spreadsheet on
the network needs to open each time someone opens an excel file in a
particular folder.

Thanks very much,
Deanna

I need to know how to modify an excel shortcut to make a file always open to
a specific named "intro" sheet.

s am using the following script to make excel open to a specific worksheet:
Sub WorkBook_Open()
Worksheets("Intro").Activate
End Sub

When A user used the intro sheet, I have a macro that then changes the name
of the file to a user inputted name and then goes to a "table of contents"
worksheet.

I need to write another macro that will then make the file that is now saved
under a different name to open to the "table of contents" worksheet and not
the "intro" worksheet when it is opened a second or successive times.

Does anyone know how to do this. Assume I don't know anything when wording
any answers.

On opening a workbook I would like it go to a specific worksheet e.g. index
page. Is there a macro that will perform this function please? Thank you for
your assistance.

Andy Josolyne

I am trying to set up a spreadsheet where I have a number of different tabs each containing the same data (it is basically costs associated with a number of different sites). I want to be able to turn on or off certain sheets so they are either included/excluded in a calculation (so I can sum by region/manager etc.).

I have a summary sheet that looks like this:

A1 A2 A3 Site Name Tab Name Included? Aberdeen Adeen Kirby Lonsdale KLons North Wales NWales

In each worksheet I have a cell (Z10)which basically says included/excluded, so I was intending on writing an if statement in the included column in my my summary here to summarise. So i don't have to write 20 odd seperate if statements is there a way that I can somehow use the tab name cells to refer to a cell...

e.g. IF(B3!Z10="included", "yes", "no")....if I try and do this though I get a cell reference error

Is this possible? Hopefull I've explained myself properly!

Thanks

If I want to select a specific tab on a tabstrip using VB6, then the following will work:

TabStrip1.Tabs(1).Selected = True

However, with VBA I get the error message "Invalid procedure call or arguement". Is there another way that I should be handling this for VBA?

Thanks!


No luck finding an answer? You could always try Google.