Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

Missing Dialog Box

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

When I click on a cell I have to press F2 to see the contenets as the dialog box at the top has disappeared for some reaon - if I have a formula in there and click on the formula option in the menu it reappears but I cannot get it to stay and when I am editing large amounts of data this is frustrating.

Help would be greatly appreciated

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Enter Text/Characters with a Double-Click of the Mouse
- This macro allows you to enter any text or number, that you specify, in a cell on which you double-click. In the exampl
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbook un
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when

Similar Topics







hi my question is a two part question for anyone that can help my problem is that i need to have an option box and when selected it will bring up a dialog box.... in the dialog box are more or less a login screen but the function it will servie is this: click the option box (named "DigitalSign")(to have your report digitally signed) then the dialog box comes up and prompts a Supervisors name and Password(there will be more than a 100 supervisor able to use the dialog box). once that is enterd correctly in the dialog box then the appriate signture will be displayed in cell N49 if the wrong or invaild info is enterd in teh dialog box it will notify an error message and then allow to click ok and then close and reset the option box to a false or emty bullet??? is it possible any help would be great im really new at this stuff




Press Ctrl+1.
Or
Select Home -> Click the dialog box Launcher arrow symbol in the bottom-right corner of Font or Alignment or Number Group.
Or
Select a cell, press Shift+F10, or right-click a cell and select Format Cells from the shortcut menu.





Select a cell containing a formula and press Ctrl+[.
The Ctrl+[ shortcut is one of the most recommended keyboard shortcuts.
It can trace a precedent cell(s) in the active sheet, in another sheet in the workbook, or in a sheet in another open workbook. It can also open a closed workbook and select the precedent cell(s) after opening it.



1. Type a number into cell A1 and then type the formula =A1 into cell D1.
2. Select cell D1 and Select Formulas -> Trace Precedents (in Formula Auditing Group).
3. Double-click the blue arrow to move between the precedent cell and the dependent cell. (Add PrintScreen of the blue arrow)



1. Insert a link formula =[Book1.xlsx]Sheet1!$A$1 into cell A1 in an open workbook.
2. Select cell A1 in the new workbook and select Formulas -> Trace Precedents (in Formula Auditing Group).
3. Double-click the dotted-line arrow to open the Go To dialog box, select the reference, and then click OK.
 To move to a precedent cell:
1. Select Home -> Excel Options -> Advanced.
2. Deselect Double click allows editing directly in cell checkbox.



The Go To dialog box holds the last four references moved to via Go To.
Select Home -> Find & Select (in Editing Group) -> Go To
Or
Press Ctrl+G or F5 to open the Go To dialog box.
Select an address and click OK.



This is frustrating, but maybe I'm just being dense. I'm running Excel 2003.
If I click on Print... and then select Preview, there is a button that says
Print... on the resulting Preview window toolbar, but it isn't Print... it's
Print (no ...). The ... is supposed to indicate a dialog.

So, to me, there are 2 problems. First is that the toolbar button is wrong.
I always think it's going to give me a dialog where I can specify
resolution, printer, color, etc., but then it just shoots the job over to
the printer. Any way to change the button and fix this bug?

Second, how can I get to a print dialog from the Print Preview window? I
almost always need to make changes to the print settings, but need to review
the Print Preview first. In virtually every other program with a print
preview option there is a way to get back to the print dialog from the
preview window. Am I just missing this in Excel?

Thanks for any help, insight, or suggestions,
Colin







Select Home -> Find & Select (in Editing Group) -> Formulas.
Or
Use the Go To dialog box:
1. Press F5.
2. In the Go To dialog box, click Special.
3. Select Formulas, and then click OK.



Hi all,

I am fairly new to VBS or macros and i am trying to do the following

Open MS EXCEL
Open an ADD-IN located at C:\Hyperion\Enterprise\rhxll32.xll
Click 'Enable Macros' on the "Security Warning" Dialog
Type in "Username" on a new window called "Enterprise Login" then press enter (Or click "OK")
Type in "Password" on another window called "Enterprise Login" then press enter (Or click "OK")
Then open an Excel File C:\H\H.xls
Click 'Enable Macros' on the "Security Warning" Dialog
Then go to (a new menu item) RXHL (Alt+U) and Click Refresh (Alt+R)
Save Excel file as D:\H\H.xls
Close everything...

I tried a bunch of different things using Macros/VBS a combination of both, but keep hitting a wall.

Any kind of help will be greatly appreciated.

Thanks




Select a cell contains a comment, select Review - Delete (in Comments Group).
Or
Right-click and select Delete Comment from the shortcut menu.
 To delete all Comments in a sheet:
1. Press F5 to open the Go To dialog box, and click Special.
2. In the Go To Special dialog box, select Comments.
3. Click OK. All cells containing Comments are selected.
Or
Skip steps 1 through 3 and press Ctrl+Shift+o (the letter o, not the number zero) to select all Comments.
4. Press Shift+F10 or right-click, and select Delete Comment from the shortcut menu.



Additional Controls Dialog Box refuses to display

I have a problem trying to add additional controls to the Controls toolbox

The two methods I've tried

1. Right click on the controls toolbox , click Additional controls

2. Menu, Tools, Additional controls

Neither of the above produce a dialog box containing the list of additional controls to choose from.

I am running Excel 2007

Any ideas would be appreciated


Need some help!
I am using Windows 2000 and I am trying to fill in the blanks in a spreadsheet that i have created, i found the method of doing it
1. Select the range (A3:A14 in the example above)
2. Press Ctrl-G to get the Go To dialog box.
3. In the Go To dialog box, click Special.
4. Select the Blanks option.
5. Type = followed by the address of the first cell with an entry in the column (=A3
in the example above), and press Ctrl-Enter.
6. Reselect the range and choose Edit, Copy.
7. Then select Edit, Paste Special, choose the Values option, and click OK.

on this site but it is not working for me, does this work in Windows 2000 and if so can anyone tell me if I am missing a step. when i get to #4 I chose blanks but there is no option for me to type anything in.

Thanks

Dan




1. Select cell A1, press
2. Select the range A1:A10.
3. Select Home -> Fill (in Editing Group) -> Series.
4. In the Series dialog box, check the Date and Month option buttons, and then click OK.
Note: To fill a series of quarters, type 3 in Step value text box.



1. Select cell A1, and press
2. Point the mouse to the Fill handle in the bottom-right corner of the cell. The cursor changes to a plus symbol
3. Drag vertically by a right-click, and then release the mouse.
4. From the shortcut menu, select the series as desired.



 To open the Insert Function dialog box:
Select Formulas - > Function Wizard (in Function Library Group).
Or
Click the fx button on the left of the Formula Bar.
Or
Select a blank cell and press Shift+F3.

 To open the Function Arguments dialog box of a cell containing a formula:
Select Formulas - > Function Wizard (in Function Library Group).
Or
Click the fx button on the left of the Formula Bar.
Or
Select a cell containing a formula and press Shift+F3.
 To insert a new Formula into a cell using the Function Arguments dialog box:
1. Select a blank cell, and then type the equal (=) symbol.
2. Type the formulas first letter and select its name from the drop down list and then press Tab.
3. Press Ctrl+A.


Or
Type the equal (=) symbol followed by the formulas name and press Ctrl+A to open the Insert Function dialog box.
 To insert a formula by typing it while being guided by the formulas syntax tooltip:
Select a blank cell, and then type the equal (=) symbol followed by the formulas name and press Ctrl+Shift+F3.



Does anyone know how to open (using VBA) the dialog box that opens when a user right clicks on the sheet menu at the bottom all the way to the left? On first right click, a box opens up listing the sheets. If there are alot of sheets, there will be a selection that says "More Sheets..." If you click that, a dialog box opens will all the sheet names. That is the dialog box I would like to open using VBA. It doesn't seem to be part of the Application.Dialogs collection. Thanks


Here are the steps in previous versions.
*****************************************
Name the Data Source Range - save your workbook
Data>Import External Data>New Database Query

'Choose Data Source Dialog Box' Opens.
On 'Database' Tab select 'Excel Files*'. Select OK.

'Select Workbook Dialog Box' opens.
- Select the Workbook.

'Add Tables' Dialog Box opens.
- Select your named range and press Add.
- Close the 'Add Tables Dialog Box'.

Double Click the fields that you want to show.

Menu bar> Criteria>Add Criteria
Add Criteria Dialog Box.
Select the field i.e Team.
Operator - select 'equals
Value - Enter the text that identifies the Team i.e. Calgary
Press Add - then Close the Add Criteria Dialog Box.
Refresh the Query by Records>Query Now

File>Return Data to Microsoft Office Excel
'Import Data Dialog Box' opens. Select the place in the Workbook Where you want the data to show - ie in the Calgary sheet. Press OK

You can then repeat for your other teams.

This should give you the list of data that you need.
If the source data changes then you can just right click in the imported data and select 'Refresh Data'
*******************************************************************

I've created the define name and I can't created the new query with the tables I need. I've tried the interactive guide but it pointed me to the customizing of the toolbars... How freakin' helpful.

Can someone show me how to do this in 2007

Thanx


I was working in a book, and went to turn off auto-calculations, but the options dialog box will not appear. When I click Tools -> Options, nothing appears. Any other item on the tools drop down that has a dialog box is functioning properly. For example, when I click Tools->Customize, the customize dialog box appears....

I have tried opening other excel files, creating new excel books, and re-booting my machine, but still cannot get the box to appear...

HELP!!





1. Select any cell in the source data, and press Ctrl+Shift+* or press Ctrl+A.
2. Select Formulas -> Name a Range (in Named Cells Group) -> type Table in New Name dialog box and click OK.
Or
Press Ctrl+F3 -> New -> type Table in New Name dialog box and click OK.


1. Select a new worksheet (or let PivotTable open new worksheet while creating PivotTable report), and select Insert -> PivotTable (in Tables Group).
2. In Create PivotTable dialog box select Table/Range box, press F3 and paste the Name defined Table and click OK.

A PivotTable is now created:





1. Select a cell(s) that contains the data to be copied.
2. Right-click the sheet tab, and from the shortcut menu, select Select All Sheets, or hold down the
3. Select Home -> Fill (in Editing Group) -> Across Worksheets.
4. In the Fill Across Worksheets dialog box, check one of the three option buttons and click OK.
5. To remove sheet groupings, hold the
Or
Right-click one of the sheets tabs and select Ungroup Sheets from the shortcut menu.




This just started a few days ago. When I right click a cell and pick format cells, the dialog menu screen displays close to the chosen cell but then it jumps to the middle of the worksheet even if it covers the chosen cell. I must then move it to another position. Some kind of setting is overriding the excel setting. I have tried restoring to a previous system checkpoint but of no use. Has anyone else experienced this?
Running XP SP2, Office 2000 SP3. All other options which display a dialog menu are also being centered.


Using Excel 2000...

I simply want to remove a hyperlink. Excel help (and several Excel help web
sites) all say to right-click on the cell with the hyperlink, and click
Hyperlink Remove. Problem is, my Excel doesn't work that way. When I
right-click on the cell with the hyperlink, the shortcut menu that pops up
displays "Hyperlink...", and clicking on that brings up an "Insert
Hyperlink" dialog box. I can find no way to remove an existing link in this
dialog.

What am I missing?





I am working on a hands on exercise for my Integrated Software Applications class...

The directions a

1. Go to www.prenhall.com/grauer...Click on Office 2003...Click the student download tab...Click the link to download the file for Office 2003 Volume I Second Edition...When the file download dialog box appears, click the save button...The save dialog box appears...Click the down arrow in the save in list box and select the drive and folder where you want to save the file...It is suggested to save the file to my desktop so that it is easy to locate...Click save...You will see a dialog box that shows the progress of the downloading operation...Close the dialog box when the download is complete...Start Windows Explorer, select the drive and folder where you saved the file, then double click the file to follow the onscreen instructions...

I cannot get it to work...I have Windows XP...

The next instruction says to click the start button, click the all programs button, click microsoft office, then click microsoft office access 2003 to start the program...

When I do this option, there is no microsoft office access 2003 option under the microsoft option...

Can anyone help me with this???

Connie


Hello All.

I need to display the numberformat dialog with the "number format" selected by default. How do I know which parameter I need to set so that when the dialog is displayed, the number format selected by default?. The following code in c# shows the dialog with custom selected .

please let me know. thanks

if (((Microsoft.Office.Interop.Excel.Dialog)Dlg).Show(Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing))
{


Hi folks,

I'm having a problem trying to automate a task in Excel because my VB formula requires a manual press of the Enter button or a click on "OK" in the Save As dialog box.

The relevant part of the code is as follows:

Code:

Application.GetSaveAsFilename( _
initialfilename:=ActiveCell.Offset(0, 1), filefilter:=sFilter)


The macro basically saves an image on the clipboard as the filename specified in the adjacent cell. This is looped so that the routine should proceed row by row:

Code:

Loop Until IsEmpty(ActiveCell.Offset(0, 1))


However, each time the function executes, the Save As dialog box appears and the macro will not proceed to the next row until I click "OK" in the Save As dialog box. I want to just save the file as the filename specified in the adjacent cell but I can't get around the manual click on "OK" to save the file. I have tried using SendKeys and simulating a left mouse click with focus applied to the "OK" button, but the problem is that the VBA function just seems to stop and wait for user input before proceeding.

Is there any way I can have the filename functionality of the SaveAs command without the manual entry in the SaveAs dialog box?

Thanks!!


When I right-click to either insert or format cells in my 2007 Excel running on a Win 8 PC 64 pro system I sometimes get only the top of the dialog box visible. Changing the color scheme does not help. Sometimes, I see a whole dialog box when I right click on a cell and sometimes I get only the top of the box. If I get only the top visible, and I keep trying sooner oir later the full box appears. The same thing happens with the dialog box to insert or remove a row or column. The problem appears sporatically, but it is very annoying and I'd love to get a fix. This never happened when I used earlier versions of WIndows.


Hi All,

I want to do the following using vba and I am having a hard time to figure it out. Any help is highly appreciated.

The following steps can be done directly in the excel.
1. Enter a sample formula in cell "C1" i.e., "=A1+B1"
2. On cell "C1", press F2 and select reference B1
3. Press F5 and Goto dialog box is opened. You can see "B1" in the Reference textbox. Click OK.
4. Now you can see that there is a marquee around cell B1 and using arrow keys you can move the marquee that changes the reference "B1" to a new value and hence changes the formula.

My requirement is as follows:
I have a userform (that has a treeview and a button) which displays all the references (ie., A1, B1) of the formula in the treeview. Now if I select B1 and click on the button. I want to go to a state as indicated in Point#4 as indicated above.

Let me know if any other information is required.

Thanks,
yaghappak


Hi there,

how do I right click in a work sheet and bring up a dialog box with information relating to a name in row 1.

for example

i have a worksheet set up as follows
A B C D
1 Smith $2355 4% 54%
2 Jones $2388 5% 56%
3 Bobby $2123 4% 45%
4 Miller $3299 8% 35%

I want to be able to right click on row 1 and bring up a dialog box with some information sourced from another worksheet relating to Smith.

I know you have to firstly write some code that inserts the macro function into your "right click" menu which I'm able to do, its just more knowing how to have a code that allows you to right click and relate the click to the specific row.

I hope this all makes sense.

easty




1. Select Data -> Sort (in Sort & Filter Group) -> Options.
2. Select Sort left to right option button and click OK.
3. In the Sort by option of the Sort dialog box, select the row number by which the columns will be sorted and click OK.



1. Select Data -> Sort (in Sort & Filter Group) -> Options.
2. Check Case sensitive and click OK.
3. In the Sort by option of the Sort dialog box, select the column title or/and add a level and click OK.