my sheet tabs sometimes disappears when I open excel. I know you can go through the start button and the advanced option to display the sheet tabs. Is there code I can incorporate so that on the opening of the excel file after the splash screen runs its course, the sheet tabs are displayed.
View 9 RepliesI have a workbook with multiple sheets. I would like to protect both the structure and window, but when I do this the sheet tabs are no longer visible when I reopen the workbook.
View 4 Replies View RelatedI am trying to create an event macro that would deactivate column and row headers when the workbook is launched and activate a sheet. i am not managing to do this,
View 2 Replies View Relatedis there a way by which i can have Excel sheet tabs on the top rather than currently at below.
View 9 Replies View RelatedI think I asked this in a much more complicated & confusing way before; hoping this makes more sense. I'd like to set something up so that when a name is entered in ColA of sheet1, it disappears from a list of names in ColA of sheet 2.
View 9 Replies View RelatedI need a macro code to color 31 excel sheet tabs with shade cyan with a click.
View 9 Replies View RelatedI am using Excel 2007. When I pulled up a workbook today with 3 sheets in it, all that comes up is the first sheet and the sheet tabs at the bottom of the screen are no longer there. I must have accidentlly pushed some button, but I can't get to the other sheets. I really need the information on the other sheets. How do I restore the view that shows the sheet numbers at the bottom?
View 2 Replies View RelatedI'm using excel 2010. I have a spreadsheet with a row that is hidden. One cell in this row contains a button. I have a macro that copies this hidden row, inserts it at another point on the spreadsheet and unhides it. It works great in excel 2007, but the button on the hidden row disappears when I close the sheet and re-open it.
View 7 Replies View RelatedHyperlinks are used to navigate internally throughout the workbook on a menu page and back. The hyperlinks started acting up after i saved to xlsm. Have since saved it back to xlsx but now the hyperlinks randomly disapper despite re-adding them over and over again.
View 2 Replies View RelatedI have been trying to get Excel (2007) to change the colour of tabs to match other tabs in the workbook
Using this code I get the colour code of the current tab
Code:
x = ActiveSheet.Tab.ColorIndex
But when I use this value in a procedure like this:
Code:
ActiveSheet.Tab.ColorIndex = x
The tab is a different colour!
I have this workbook in which each sheet refers to a month in a specific year (e.g. Jan12, Nov13), plus an "overall" sheet where I would like to, among other stuff, create a button that would lead me to the sheet refering to "today's month".
Although I know how to create a "static" macro that leads me to a particular sheet, I don't know how to create one in which the sheet it refers to is changing every single month.
(Note: I'm using Win7, MSExcel 2010)
Am using a VB for auto transpose values to sheet 2 from sheet 1 in MS EXCEL 2007.
What code to add to the already existing VB so that if someone is using the sheet and leaving the cell in E12, for example, and saving it, then the next user should find it again on A3 but not on E12.
The sheet should always open on A3..
This is weird - if you delete a sheet that contained a control then
a. showing a modeless userform resluts in a userofrm that goes invisible at subroutine End
b. public variables lose their value
These things do not happen if the sheet did not contain a control. Attached is an example file - put the inputfile.xls in your default file location (or add a path in the code) then open the ProblemDemo.xls and run the main macro to see it fal - isthis another Excelbug I've found?
when I open my sheet on another computer, all cell value which contain formula show no value. just blank. formula is link to same workbook on different tab. when I save as again on my desktop, all value appears. excel 2007 is using.
View 3 Replies View RelatedI need to batch open some hyperlinks from a long list of hyperlinks in my excel sheet. I would like these to each open in a new tab of my web browser. Is there a way to do this?
View 6 Replies View RelatedIs it possible to Sum across sheet tabs, if so how?
View 8 Replies View RelatedI have a spreadsheet with around 250 tabs, all with a small amount of information on laid out int he same format. My question is can i collate this into one long tab?
View 5 Replies View RelatedHiding sheet tabs. can you hide tabs on excel?
View 4 Replies View RelatedI need to get rid of the option to DELETE a sheet. However, when I password protect the WORKBOOK (which does this fine) none of the Macro buttons will execute, even with Macro security settings set to ENABLE ALL.
Looks like I will need some VBA code to not allow any of the sheets in the workbook to be deleted.
Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula?
A1 has a drop down list. When a name (Bob's Sales) is selected from the drop down list, B1 shows the value of cell D5 from sheet "Bob's Sales".
I've got a bunch of worksheets that I'd like to re-arrange in alphabetical order. Anyway to do this quickly? Or do I just have to drag and drop them myself? (WXP, Excel XP).
View 9 Replies View RelatedIs there a way I can lock the sheet tabs so they cannot be viewed or turned on by anyone except me?
View 9 Replies View RelatedHave designed a spreadsheet in 2003 at work and got home to work on in it using my machine which has 2007 loaded.
Have hidden the sheet tabs on the 2003 sheet and can not find the option in 2007 to make them visible again.
I realise I can ctrl-pgup and pgdn but I got a fair bit of movement from sheet to sheet to do and that wont be practical.
I know excel has a built in function for this. But it won't do what I need for this below.
Say, I have 9 worksheets open. In cell N7 on sheet 1 I need it to count the worksheet tabs.
But the dilema is to only count the tabs that will equal sheet 1, sheet 2, sheet 3, sheet 4, sheet 5, Notice, I have a space before the number. Other sheets have a specific names to them which I do not want to count.
So if sheets 1 thru 3 are visible with the other named sheets visible cell N7 will count 3
My wife and I run an apartment complex with 2 employees, a manager and a maintenance man.
We use excel to produce a paystub for these employees twice a month.
There are a number of variables including incentives for renting apartments, overtime, variable hours in a pay period etc.
We have a separate spreadsheet for each employee and a separate sheet tab for each pay period named for the pay date... e.g. the first paystub had one sheet named "Jan 15"... the next pay period the paystub had 2 sheets: "Jan 31" and "Jan 15". The third paystub had 3 sheets and so on.
The paystubs have a column with the numbers for the pay period and then a column with the year to date sum (for straight pay, over time, federal withholding, social security, medicare, state withholding, etc.)
Right now I edit the formulas for all these sums for each payperiod. e.g. =sum('Feb 15':'Jan 15'!B35) for the third pay period is editted to =sum('Feb 28':'Jan 15'!B35) for the fourth pay period.
I would like to be able to just copy the prior spreadsheet and not have to find and replace values in 11 spreadsheet cells for each pay period.
I have figured out how to get the name of the current spreadsheet to appear in a cell on that sheet using VBA... but not how to get that cell content to be part of the arguments for =sum(. on the formula bar...
I am pulling my hair out trying to figure this out. Any help at all is greatly appreciated. I created a spreadsheet for a friend to track his profit/loss for his business; he is not very computer literate so I created separate tabs for each month. I have no idea what he did but the horizontal scroll bar and all of the tabs are not visible, he is using excel 2000 on windows XP. Unfortunately we are not in the same area so I can’t go look at his screen. When he emailed the file back to me and I opened it, it looks fine. Also when he opens any other file it does the same thing. I have gone through all of the obvious causes, everything is correct in the tools, options.
View 8 Replies View RelatedI have a lot of sheets, in my workbook. It keeps expanding, as I add them. How do I make multiple rows of sheet tabs, to keep from having to scroll across all the time?
View 4 Replies View RelatedI am using the following codes to hide the menu, formula bar and the headings. One more thing I need to do but do not know how - hiding the tabs at the bottom of the sheet. The idea is not to let users to right click and unhide other sheets.
'Hide main menu
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
'Hide headings
ActiveWindow.DisplayHeadings = False
'Hide formula bar
Application.DisplayFormulaBar = False
Just created 1800 sheets by not closing a loop, just wondering if anyone has a quick solution to delete all of these apart from the first three.
View 4 Replies View RelatedI have a file that will have a maximum of about 25 tabs in it. They are all the same format - Column A have account codes, Column B have the account name and Column C through to Column AD have figures. Column B has a drop down menu, so not all tabs will have the same account code on the same row.
I thought that I would create another spreadsheet in the file and call it a master sheet with the same formats as all the other tabs but this master file will have all of the account codes available and will not have a drop down menu in column B. What I wanted to do was consolidate all of the 25 tabs in the master sheet.
Example Worksheets
TAB 1
Acc Code Desc Amount
1________a___10
2________b___10
TAB 2
Acc Code Desc Amount
1________a____10
2________b____10...........