Opening Worksheet-nothing Shows
Mar 4, 2007
I'm having an issue with a worksheet that I created. Apparently, every time that I go to open it, it gives me a Grey blank screen. Yet, I know the worksheet is behind this Grey screen. I went to full screen and I can see the work sheet in full view, but it always opens in this Grey screen. I'm not sure why its doing this, no other worksheets open in this matter. I have tried reinstalling excel and it still didn't fix this problem. But it is only happening with one particular worksheet. I'm sure it is just a setting that I might have changed, but I can't figure it out. The file isn't corrupt because the macros still work, I tested them.
View 7 Replies
ADVERTISEMENT
May 9, 2014
Please see this attached image: HowTo Do This.PNG
I have this worksheet that I did not create and notice it has entire rows and columns completely gone / deleted. For example, the only columns it has ranges from A to AI and then no more columns exist in the worksheet. For the rows, it has rows 1 through 77 but then it shows a gray background.
How did they do this? What is this called? How can I do this to Worksheets?
View 4 Replies
View Related
May 2, 2014
I was given a workbook with several bugs and asked to fix it and make it functional again. I was able to fix everything except for a runtime error 1004. On the debug it highlights the following code:
Code:
Private Sub ComboBox1_Change()
End Sub
Private Sub Worksheet_Activate()
LoadSheetNames "Compare_Session_Start", "Engineer*"
End Sub
Private Sub LoadSheetNames(strRangeForValidation As String, strDesiredCodeName As String)
[code]....
Anytime you select the base worksheet or a duplicate it shows the runtime error...
View 2 Replies
View Related
Jul 8, 2006
I have a workbook with loads of various worksheets,, which is shared between a group of us.
What i want is that each time the workbook is opened it always starts on the same worksheet called 'main'.
View 5 Replies
View Related
Nov 17, 2009
get a message box pop up upon opening of workbook no matter that tab its saved at.
View 3 Replies
View Related
May 10, 2007
how does one run code, particularly to rearange some columns upon opening a worksheet?
If A > D Then
{A=D
B = E
C=F}
and
{D=A
E = B
F=C}
End If
View 9 Replies
View Related
Jul 13, 2006
Is it possible to have a text box and a macro button that when a user enters a name of a folder (or part of the name) on say the c: drive it takes you there? Example being i have a folder called Alcan Inc on my c: drive, so i type in the text box alcan and click the macro. it then opens a windows explorer screen with the folder open.
View 2 Replies
View Related
Jun 9, 2006
I have a userform where I have 2 comboboxes. The first combobox shows the the first column (only 1 of each) and the second comboBox shows me the secondary list that correlates to the valuse in the first from column B. Now I have a text box that I am trying to get the value from column C depending on what I have in the first 2 comboboxes. What is the easiest way to do it? This is all in VB since it is a UserForm, and using Vlookup seems to be too many lines if I go that route. Is there a way to use Index and Match in VB where it would be more efficient? I attached just a sample of how the data would be layed out in the Excel sheet.
View 4 Replies
View Related
Mar 6, 2014
I'm having a problem to use the macro for opening a specific worksheet in a workbook. My plan to setup the workbook to open the first worksheet no matter which worksheet that was last saved and close.
What i have in mind is like below macros but it is not working.
Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub
Attached is the sample for the workbook. Test file.xlsm
View 3 Replies
View Related
Jul 22, 2008
Anyone who opens my sheet, has to feed his/her name which will be appeared in a particular cell.I am using the below code.
View 12 Replies
View Related
Jul 20, 2009
how to update a function when opening worksheet. I made
View 4 Replies
View Related
Jun 26, 2013
I have this VBA work fine for me but I want to chage this to when it copy then it select active sheet and active cell.
Sub test()
Dim wb As Workbook, wb2 As Workbook
Dim ws As Worksheet
[Code]....
View 3 Replies
View Related
Dec 12, 2007
I wish to send a message when a worksheet is manually opened, but not when it is activated from within VBA.
The following code does not work, and I am open to suggestions
Private Sub Worksheet_Open() ....
View 9 Replies
View Related
Dec 12, 2008
I have the following code, which I use to open up a .xls file generated from Crystal Reports:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim fexport1 As String ' variables for the exported file
Dim fexport2 As String
Dim wb1 As String 'variables to change between the opened workbooks
Dim wb2 As String
strTemp = "Please Choose The Exported File"
MsgBox strTemp
fexport1 = Application.GetOpenFilename("Excel Files (*.xls), *.xls)")
If InStr(fexport1, "False") = 0 Then
Workbooks.Open fexport1
wb1 = ActiveWorkbook.Name
Else
strTemp = "Operation Canceled"
End If
The problem is that Crystal Reports generates the file with an invalid worksheet name (it contains a backslash) and I do not have access to modify the Crystal Report. Althought the file can be automatically repaired by Excel when manually opened, the macro chokes and the "Application.DisplayAlerts = False" does not fix it. The only solution I can think of is renaming the worksheet without opening the file.
View 9 Replies
View Related
Aug 25, 2006
if you open a workbook & choose not to enable macros, is there any way to later change your mind & set macros to enabled without having to close & reopen the workbook?
View 9 Replies
View Related
Nov 22, 2008
I would like the workbook to open to a specific worksheet everytime it is opened regardless of what worksheet it was in when file was saved. Can someone point me in the right direction?
View 2 Replies
View Related
Mar 11, 2014
I have software that exports to an excel file. The files are one or two page reports. The way the software dumps the reports into excel, it comes out looking pretty rough. The rows and columns aren't spaced very well, the fonts look like garbage, and nobody likes them.
I would like to apply formatting changes to these reports automatically without the end user having to do anything. So as soon as the document is opened up it bolds the column headers, adjusts column widths etc. The reports are auto generated so no formatting can be done when the reports are made.
There may also be different formatting done to different reports. The files will come out named something like, "Report_A_DDMMYYY.xls, Report_B_DDMMYYY.xls," etc. Report A, and Report B will likely need different formatting.
I'm not opposed to using VBA or whatever might be necessary to make this happen. I can learn anything I need to pretty quickly, I just don't know where to start with this.
View 4 Replies
View Related
Jan 25, 2007
I have a workbook that contains worksheets whose sheetnames are specific to each day of the month ie: 1st 2nd 3rd 4th 5th, and so on up to 31st. I am trying to write an workbook open procedure to check the day of the month and match it to the relevant worksheet so it will open to that day. for example if opened today being the 25th, i want the code to unhide sheet named 25th and select it, whilst all other sheets bar one is hidden.
View 5 Replies
View Related
Jul 13, 2012
I am trying to have an operation run when opening the Workbook. The UserForm opens fine, but I get an error when the GoButton_Click sub runs. The error file is not very comprehensive.
The user is promoted to 'Delete' or 'Cancel' before the sheet is deleted. I do want to select 'Delete' for the user, but I'm not sure how to do this.
The error mentioned occurs after the user selects 'Delete'. The error is:
Run-time error '-2147417848 (80010108)':
Automation error
The object envoked has disconnected from its clients.
VB:
Option Explicit
Private Sub UserForm_Initialize()
Me.Choices.List = Array("Choice 1", "Choice 2")
End Sub
Private Sub GoButton_Click()
If Templates = "Choice 1" Then
[Code]....
View 5 Replies
View Related
Feb 6, 2014
I have a workbook with two worksheets, "Main" and "Control".
Both of them are with hidden tabs (unchecked "show sheet tabs").
On worksheet "Main" I have command button which opens worksheet "Control".
The assigned makro is: Sheets("Control").Select
The problem is: when I open "Control" and close after that the workbook, the next time when I open the workbook "Control" pops-up instead of "Main" even though I do not save it.
1. I need macro on "Main" which will allow me to open "Control".
2. Regardless I "Save" or "Don't Save" "Control" when selected and workbook is closed, to open the workbook always displaying worksheet "Main".
I use Excel 2007 (at home) & 2010 (at office).
View 1 Replies
View Related
Aug 26, 2009
I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.
View 6 Replies
View Related
Apr 17, 2007
I have a need to open a file from my companies intranet. My current method was to open said file via the method that the recorder gave me. However, I would like ot be able to open a said file without having to start open another workbook.
This is the path:
[url]
So the command is this:
Workbooks.Open [url]
Links are not actual links
So what I need to know. Is how can I open this file without opening a workbook. I haven't been able to use the VB "Open Statement" to open a file and I don't believe that I've been successfull using the Filesystem object either.
View 9 Replies
View Related
Dec 10, 2009
why my zero totals sometimes show as 0.00 and other times as (0.00), when they have the exact formula?
View 2 Replies
View Related
May 12, 2008
got this quite complciated formula.
any of the cells specified can be blank at start of spreadsheet
is there a way to hide the DIV/0 error from appearing
this is the formula:
=((((((SUM(C11:C14)*(100%-R2)+(SUM(ThroughputFormulas!C33:C36)*R2)*(L2/30))/1000)*N2)*3600)*P2))/(SUM(C39:C45))/1024/8
View 9 Replies
View Related
Jun 8, 2006
PRODUCT shows a value even if 0*# =IF(H15*I15=0,"",PRODUCT(H15,I15))
View 5 Replies
View Related
Mar 5, 2009
I already have a conditional format which is working OK. I would like to put a formula in the cell so it shows a % so currently it would be 100% as there is 3 cells below showing 3 greens.
Alternativily each colour is worth a value - Green = 1, Amber = 2, Red = 3. So Cell I3 would show 3.
View 2 Replies
View Related
Oct 14, 2013
I have a problem with my formula. As you can see, i want to get the CIM number of the Team Leaders (TL Name) when i change the dropdown list of the campaign. But what im getting is the repeated CIM numbers.
Here's my formula:
=IF(ISERROR(INDEX('Team Data'!$F$2:$F$5489,SMALL(IF('scorecard (OM Search)'!$C$12='Team Data'!$E$2:$E$5489,ROW('Team Data'!$E$2:$E$5489)-MIN(ROW('Team Data'!$E$2:$E$5489))+1,""),ROW(A1)))),"",INDEX('Team Data'!$F$2:$F$5489,SMALL(IF('scorecard (OM Search)'!$C$12='Team Data'!$E$2:$E$5489,ROW('Team Data'!$E$2:$E$5489)-MIN(ROW('Team Data'!$E$2:$E$5489))+1,""),ROW(A1))))
View 1 Replies
View Related
Feb 27, 2014
I want a macro to show a message with a content in the cell B3.
For EG: "Rec as of 'B3' is created"
This has to be the message and 'B3' has to be the content in the cell B3.
I tried doing it but i am unable to show the content in B3 in the message.
View 3 Replies
View Related
May 31, 2009
I'm using Excel 2007 and have created a spreadsheet for invoicing. I have created a dropdown list which then imports the address data using vlookup.
My problem is this. If there is no text in say, address field 4 the resulting field in the invoice shows as a 0 eg,
NAME
ADD1
ADD2
ADD3
0
POSTCODE
Is there a way to move the Postcode to the empty cell showing 0? and/or how do I make the cell to show blank instead of a 0.
View 6 Replies
View Related
Jun 19, 2014
I am trying to create a basic invoice spreadsheet.
On worksheet 1, I have days of the month A4 to A35. Columns B, C, D, E are headed.
Every hour of work I would enter a " 1 " in the correct cell for the day. For example, 1 hour, every segment of the day, I would enter "1" in cells Bx, Cx, Dx and Ex. This continues for the month;
On a 2nd worksheet, this is neatened up, and I have added formulas to work out the cost and type of call;
On the third worksheet, I want to display roughly the same, however when there has been no work on the day (ie the date displays "None" and the adjacent cells show: blank, blank, blank, blank, £0.00), I want it to skip the cell and display the next date which has data to show (ie a date). The data on the adjacent cells needs match with the date (in the same way as physically deleting a 'non worked' whole row).
This then on the invoice worksheet would look neat and display only the days actually worked.
What formula(s) could I use to do this.
View 1 Replies
View Related
