I have an Excel 2007 workbook that's been used for 5 months or so now. Recently, people I email it to say they can only see one worksheet in the workbook when they open it, and are unable to switch to any other worksheets in the workbook (they can't even see the tabs). They are in the "normal" view, and I have no idea what else could be wrong. Did I mess something up with the protection? Any other ideas to check?
View 4 Replies
I've received a workbook that contains maybe 60+ worksheets. To navigate the workbook, a person must use the hyperlinks on each sheet. However the worksheet tabs do not appear at the bottom of the sheet. I've checked Tools / Options / View / Sheet Tabs and the checkbox is checked. II've also tried unchecking and rechecking the box.) There are no custom views created.
View 2 Replies View RelatedI am trying to set up a macro so that when I receive updates (via email), I can simply hit a button and the information is copied into my workbook.
This is what I have however i get a 'Runtime error 9' which I believe means the references don't exist, I have double checked all my workbook/sheet naming and all is correct.
With Workbooks("Database").Sheets("Database").Range("A1:AP5000").Copy
ThisWorkbook.Sheets("Database").Range("A1:AP5000").PasteSpecial Paste:=xlPasteAll
End With
I be addressing the copy method in a different way.
I use a workbook where new worksheet tabs are added and removed daily. Every day I use the second-to-last tab (2nd from the right) and the last tab (far right). What code would enable me to activate and reference both of these tabs individually? I believe it would be something like the code below but I can't figure it out...
View 5 Replies View RelatedI've just started using Excel 2007, and despite manually activating the add-ins I use, the add-ins tab is not showing on the toolbar. Also, I can't find the format tab either.
View 6 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 a cell that contains the =Day1!G4. It reveals what is on another worksheet, but I want to be able to have the next cell be: =Day2!G4. Is there any way that I can code this without having to physically type in every cell? I tried, =Day1+1!G4 but it didn't like that.
View 12 Replies View RelatedI and a colleague are working on some code to automate a web page. We've been able to get it to fill in the needed forms, run a report which comes out in Excel format and save the output to a specified shared drive location.
However, when we attempt to close the resulting window we are unable to...
The webpage creates a new Internet explorer window which we're able to capture and do a wb.saveas, but when we do wb.close, it does not generate an error, but the new window does not close.
In the VBE, the workbook is visible as an object, but in Excel if you go to Windows on the main menu and attempt to select it, it's not listed and the Unhide option is greyed out.
So the object is a member of the workbooks collection for the VBE, but not Excel...
1. I'm looking for a better way to get a UserForm (frmParts) to show right from the start as soon as I open the workbook while hiding the application. I use the following when I initialize the application:
Code:
Application.Visible = False
frmParts.Show
2. Later on, I add some parts to my inventory, but if I don't make the application visible, it doesn't save the data. So, I have to make it visible and then hide it again. Is there a right way to accomplish the save without having to unhide/hide the application? This is the applicable code I used (ComboBoxes & TextBoxes involved):
Code:
'copy the data to the database
Application.Visible = True
Application.ScreenUpdating = False
With ws 'ws=Inventory
[Code] ..........
I have a workbook which will open another workbook on a server, but i see it on the open and close on the task bar. Because I have 4 pc's with the main workbook open as single applications and one book on the server which collects info everytime a button is pressed, I would like it not to show on the on the task bar, needs to be invisable, is there any way of this?
Also
Can i see if a workbook is open, regardless of which PC (out of 4), which may not be the one i am using. So a way to see if a workbook is open anywhere else?
I have downloaded a custom menu workbook attached. I am wanting to only show the custom menu in one workbook as it appears in all workbooks open at the time.
View 3 Replies View RelatedI have created a form that converts latitude / longitude from Decimal Degrees to Degrees Minutes Seconds decimal seconds. I want my coworkers to be able to use the form, but I don't want them to see the excel window/worksheet when they open it up.... I thought I had received an email once that appeared to be an excel file but when you opened it, it was just a form. I have tried all I can think of to no avail.
View 3 Replies View RelatedI have two workbooks (Book1 and Book2). When Book1 opens, its Workbook Open procedure displays a Userform1 that has two Command Buttons. The first Button closes Book1 (exit the program). The second Button opens Book2. Book2 has a Workbook Open procedure that should close Book1 and display a new Userform2. When the Workbook Open procedure of Book2 closes Book1, the procedure stops there and does not show the UserForm2. How can I get the Workbook Open procedure of Book2 to execute both steps of closing Book1 and showing Userform2? This must be done by clicking the second Button on Userform1.
View 9 Replies View RelatedI used to be able to see on the bottom bar that there are several Excel files that are opened. There would be a small black triangle next to the Excel button below. But now I need to do click the 'Window' button above to pull down the menu to access to other Excel files that are opened. This problem is only with Excel but not Word or Powerpoint? Is there a setting I must do in Excel? Auto Merged Post Until 24 Hrs Passes;
View 2 Replies View RelatedI have the following code that displays a form at a user defined time and if the user does not press "Stop" then the workbook saves and closes. The user can press stop then the workbook remains open.
Here is what I have where:
Admin_Auto_Shutdown = Yes or No
Admin_Auto_Shutdown_Time = 3:34pm or user defined time (This doesn't seem to work??)
'Auto Shutdown CloseandSave
If UCase(wb.Worksheets("Admin"). Range("Admin_Auto_Shutdown").Value) = "YES" Then
Application .OnTime TimeValue("Admin_Auto_Shutdown_Time"), "AutoShutdown"
End If
Sub AutoShutdown()
Application.OnTime TimeValue("Admin_Auto_Shutdown_Time"), "AutoShutdown"
Auto_Shutdown_Form.Show
End Sub
Now, my question is about a timer that I can show on a form. When the form is displayed I would like to give the user 30 seconds to press stop (and keep the workbook open) or to press proceed and save and close or to not do anything and the workbook would close and save when the timer reaches zero.
Code for user form which is missing most everything...
Private Sub Halt_Click()
'If user whats to continue without closing
Auto_Shutdown_Form.Hide
End Sub
Private Sub Proceed_Click()
'If user whats to save and close
Auto_Shutdown_Form.Hide
How do I add a timer to this code where it will run this at the end of the timer?
Auto_Shutdown_Form.Hide
Application.DisplayAlerts = False
With ThisWorkbook
.Saved = True
.Close
End With
I have 3 workbooks with multiple spreadsheets (tabs) in each workbook. I want to open a blank workbook and copy various sheet tabs from the other workbooks into my new workbook. I need to keep the formatting etc when these are copied over. There are text boxes in some of the existing workbooks and macro's.
View 2 Replies View RelatedWorking with an existing macro from this forum. How do I create the array showing the number of sheets found? I know from a MsgBox that two sheets are found.
View 3 Replies View RelatedI have a workbook with several tabs. The top tab is the main spreadsheet
were I enter all my gathered data. The other tabs are the same spreadsheet,
the same data, but broken out by specific building.
Right now, I enter the data (alpha and numeric) into the main spreadsheet,
then manually copy/paste it to the respective sub-level spreadsheet.
I can specify the "IF" part of the line item that would identify which sheet
to copy it to, but is it possible to have a "THEN copy and paste [these
cells]" to the other spreadsheets?
How can I get the worksheet tabs to show?
I have gone to : Tools,option and the sheet tabs box is checked
I have a workbook that pulls in data from other sources and contains 15 linked sheets. The data changes when different criteria is selected in the first sheet. The first 2 sheets are summary sheets and the tabs are named correctly.
I would like to be able to rename the remaining 13 tabs using labels found in the cells in the first sheet. These tabs should update or change when the first sheet is manually recalculated (F9).
I have used ActiveSheet.Name=Range("A1") but it doesn't apply in this case. Is there a macro that could run with something like Sheet1.Name=Range("A1"), Sheet2.Name=Range("A2"), Sheet3.Name=Range("A3"), etc.... or maybe something in each sheet that would change the name of the tab to a specific name off sheet 1 when the whole workbook is recalculated?
Just wondering if there's a "codeless" way to print en entire workbook (i.e. all tabs) without moving from tab to tab and hitting print?
View 1 Replies View RelatedI have to prepare files of over 100 tabs in each. I have a list of numbers on a spreadsheet that must be entered on each tab. Am I making myself clear because I tried to do it manually and it's no joke?
View 1 Replies View RelatedIs there a way to Sort all the Tabs in a Workbook by the Tab name?
View 1 Replies View RelatedI have a program that takes a templete, copies it, fills in some information and then renames the tab based on text in a cell on that sheet. The code loops so I end up with about ten tabs that are created from the Template.
I want to move these newly created tabs to a new Workbook.
is there a way (code) that will move all the tabs except ones delineated in the code - like the tab named "Template"?
Is there any way to arrange the tab easily instead of move back and forth and drag? I have a work book with 50 tabs and if I like to arrange it, I have to move the cursor pointer zillions time and than find and drag the right tab at the right place. Is there any easir way? Like you do in power point?
View 6 Replies View RelatedI made a workbook with several linking tabs and then moved the tabs to various folders. Why can I view the updated info on my cpu but others can not?
View 9 Replies View RelatedI can only view one worksheet at a time with a particular spreadsheet. There are no tabs to click at the bottom of the screen to view the other worksheets. In excel 2007, if I click on View, then Full Screen, I get the tabs (so I can view the different worksheets) but then I lose the menu and formula bar (so when I click on a cell I can only see its contents and not the formula). I need to see the formula that is applied. This has not happened with other S/Sheets, just this particular one. what else I can do to view the worksheet tabs without full screen view?
View 7 Replies View RelatedIs it possible to name a worksheet tab from a cell reference on a worksheet?
View 6 Replies View RelatedI have been presented with a rather odd thing with Excel. We have a wookbook with six worksheets in it. When the first of worksheets is displayed, all the other tabs "disappear". The whole bottom tool/navigation bar is no longer displayed. How can I get it back?
View 8 Replies View Relatedi got a question for anyone to help me with. i need help in figuring out how to type in a cell (A1) making it changing the worksheet tab as well. I watched Episode 452 of mrexcel's podcasts, but i cant see the text that he typed in. Can anyone help me with this problem or link me to another post where this same problem has already been answered.
View 6 Replies View Related
