Pull Down Menu Bar
My pull down menu bar has disappeared from my excel worksheets. Not sure
what I did to make this happen and cannot find anything in help except for
toolbars. Can some one please tell me how to get the pull downs turned back
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to get to the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true
JB in Kansas wrote:
> My pull down menu bar has disappeared from my excel worksheets. Not sure
> what I did to make this happen and cannot find anything in he...why do my drop down boxes not show up
When I click one of the items on the toolbar, such as "format" the drop down
box is invisible. How can I fix this?
...Auto Adjusting Text Box
Is there any way to have the text box auto adjust the height in a protected
form according to the amount of text a user inputs? Thanks! Jae
...Size of Validation drop down box
How can I increase the size of the Excel data validation
box to see more options from my list of selections?
not possible, sorry
> How can I increase the size of the Excel data validation
> box to see more options from my list of selections?
...How to find Tools menu
Hi there - I'm trying to configure my Accounts and can't find my Tools Icon
in the Menu Bar - is it located in some secret place?
Have tried to 'restore' under standard and advanced menus in case I had
deleted it somehow, but it's still not appearing
Any help much appreciated!
Which menus do you see now? By default they are the following;
File | Edit | View | Go | Tools | Actions | Help
Otherwise force a reset on your Toolbars by renaming outcmd.dat to .old. For
Robert Sparnaaij [...Popup menu problem
i've got a problem with a popup menu.
I'm writing a dialog based application,which lets the user display a chart
in a second dialog.
In this second dialog, i let the user choose the range for the plotted
quantity by means of a popup menu,which opens a third dialog to let the user
choose the range.
The problem is here:when this third dialog (a modal dialog) opens,it's
opened above the main application dialog,causing the "chart dialog" to be
under the main dialog and the third dialog.Instead, i would like thi third
dialog to open above the chart dialog(the second...LED light box display--Only 11 mm LED slim light box in China!
Edlite is dedicate to develop comprehensive technology on advertising
light-box including LED; CCFL; EEFL and FLUORESCENT series.We already
sell numerous light boxes around the world for tradeshow booth or
More info,please enter into www.edlite.hk or mail firstname.lastname@example.org.
Edlite really appreciate for your support!
...Security Dialog Box
The message "Do you want to show only web pages with secure..." is backwards
in its logic and very confusing.
Needs to say something like "Do you want to block this insecure content?"
This is such an onerous violation of Microsoft's own usability standards
that I am looking to turn off the security setting that generates this
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do n...Menu add-on Positions
I am using Office 2003 Pro. Is there a way to control where menu add-ons
are positioned? I recently installed Adobe Acrobat and it has a PDF menu.
Each time I open a new window to send an email it is in a different position
on the menu bar. I drag it to where I want it and next time I open up a new
window to send an email it is back on its own line up on the very top of the
menus. Also, if I right click to have it not show up on the menu it goes
away until the next time I open the new window to send another email.
Milly Staples [MVP - Outlook]
Post all replies to th...Presentation Properties
I have PPT 2007. I have always wondered how to make good use of the
Powerpoint Properties dialog box.
How can Keywords and Category, for example, be put to good use? What
searching system can look inside the properties? Are any properties
useful for SEO if a presentation is posted on a website?
In article <51fec317-0258-4865-8da6-
email@example.com>, Alessandra wrote:
> I have PPT 2007. I have always wondered how to make good use of the
> Powerpoint Properties dialog box.
> How can Keywords and Category, for example, be...Exchange mail box
I am trying to use exmerge to archive a mail box, but when ever I try I get
the following error message: Error configuring message service (MSPST MS)
Dose anyone know how i can go about fixing this problem.
I also have tried to open the box but I am unable to do that also it tells
me that the exchange server cannot be contacted.
what version Exchange?
"Takia" <Takia@discussions.microsoft.com> wrote in message
> I am trying to use exmerge to archive...Custom Project Workspace Not in Dropdown
I created a new Workspace Template for PS 2007 according to the instructions
posted on the Project Experts site:
However, after everything proceeding as described and the template showing
up in the available templates for creating new general sites, the template
still does not show as an option for default site provisioning.
I'm an admin on the server and for PWA and I didn't receive any error
messages. Any ideas what the problem could be?
Thanks in advance.
Have you restated the...How to stop users from pasting over list box cells?
I have created an excel worksheet that uses validation to force the
users to select a value from a list box. This was great until users
figured out that they can over-right the cells by copying and pasting
into the cells.
How can I stop them from being able to paste over these cells?
Any help would be greatly appreciated! Thanks!!!!
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
This won't stop them if they're industrious, but if they do th...dealing with dialog box
i have created a dialogbox and tab control on that dialogbox. But they
have standard colors.But i have make new colors to them. how can i do it. If
possible plz explain with an example.
Make an owner draw tab control. Check out codeguru.com for some
The tab control in the Xtreme Toolkit has colored tabs (I use them).
(www.codejock.com). I think the Ultimate Toolkit has this also
(www.dundas.com). If you are going to do any significant GUI using MFC you
may want to check out one of these toolkits for useful gizmos. They have a
...Several combo boxes (with "All" option included) in a form/subform
I built first a form with 3 combo boxes (all of them with the "All" option
created using a Union query) and a subform. Form and subform are linked
(Master/Child fields) using the combo boxes. I also tweaked the SQL code for
the subform query, following advice from this forum, so that any combination
of choices (including the “All” option in all of them) in the 3 combos
generates the right set of records in the subform. Perfect so far, with 3
combos, because the number of combinations is not too much. But if I try to
expand to 7 combo boxes (i.e. 7 different fields to ...newbie: How can I get the querystring from the presenter?
I wonder how I can get the querystring from within the presenter?
> asp.net 4.0
> I wonder how I can get the querystring from within the presenter?
Sorry, I thought there was only one type of presenter in the .net framework
"Mr. Arnold" <Arnold@Arnold.com> wrote in message
> Jeff wrote:
>> asp.net 4.0
>> I wonder how I can get the ...save box grayed on opening attachments in outlook 2000
I can open office documents directly from outlook by just
clicking on them no prompt it just opens (ie:word) also
when opening non office attachments i get this box with
save open grayed out
how can i fix it so i can either save from here or just
open my paint program with out the prompt box?
...One I type in one box in Publisher, it changes copy in another
I am editing a trifold brochure, when I type in one text box, it changes the
type in another box. How do I get that to stop????>
It sounds like you've locked three text boxes together or you have only one
text box covering the three panels.
Unlock the three text boxes or make three text boxes, one for each panel.
"marmar328" <firstname.lastname@example.org> wrote in message
>I am editing a trifold brochure, when I type in one text box, it changes
> type in anoth...Graphs not present
I cannot seem to be able to view graphs in Excel 2002.
Which graphs would those be? Graphs you created? Graphs in a workbook that
was sent to you?
More detail please.
Gord Dibben Excel MVP
On Mon, 12 Jan 2004 11:24:32 -0400, "DMJ" <kmd@hotmail> wrote:
>I cannot seem to be able to view graphs in Excel 2002.
...Linking a one Presentation to Another Presentation
I have several presentations that are linked to my main presentation so when
you click a link the secondary presentation opens up. My problem is that
everytime I click a link that new presentation opens, which is good, but it
doesn't close when I link back to the "home page". Is it possible to have a
presentation close when you click the link back to the home page?
This sounds like a PowerPoint question?
On Mar 17, 8:49=A0am, ElizabethS <Elizabe...@discussions.microsoft.com>
> I have several presentations that are linked to my main presentation so...Tax box on POS
My Store OP POS seems to have a new problem with retail taxes.
Every item has been assigned as tax item. Also, to make sure all sales
taxes are calculated, I assigned customer taxes as well.
A few items from the database still came up untaxed at the point of sale
even though all have been checked and assigned as tax items. Z report also
has been made. We have to remind the cashiers to double check the text box
for every item at the point of sale.
Did anyone have this problem? I think I am finding many problems posters
here don't identify with because few are running apparel st...Fixing Comment Box Position!!!!!
I have a worksheet that I have put comment boxes on numerous cells.
have coded the sheet to display the comment box when the cell i
selected. I am now running into a problem because the size, shape an
position of my comment boxes will not stay where I initialy set them.
Is there a way to fix the size and position of my comment boxes?
want the box to display the information in an ideal location on th
page. Please Help!!!
Message posted from http://www.ExcelForum.com
You have no control over where comment boxes appear.
You do have contro...Presenting and hiding the Naviagation pane
I can press a key sequence (Ctl+N) and get the Navigation pane, but is there
a mechanism to hide it via a key stroke, such as Ctl+Shift+N?
The personal opinion of
Gary G. Little
No, but you may be able to create one using an AutoKeys macro. Create a
function in a standard module named something like basUtilities (aircode):
Public Function HideNavPain()
DoCmd.SelectObject acTable, "MSysObjects", True
You can change acTable to acForm and use one of your form names. Now create
a macro and name it AutoKeys. That name is a...Raptivity Presenter
Trying to get my head and a presentation wrapped around the new =
Raptivity Presenter. It really looks great, and I have been working =
with it a bit, or trying to, as time allows, which is not as much as I'd =
like. I have covered all the info and samples on the Raptivity website, =
but, I still don't fully understand how it works in the PPT =
presentation. Also, as I understand, it only works in PPT apps, which I =
rarely use anymore, and does not work with the PPTX.=20
I was wondering if anyone here has tried it and might have some tips, =
suggestions, recommendations or...inserting combo box in list control
I want to insert a combo box in one of the columns of list control. What are
the steps that i need to follow to achieve that??...any tutorial or code
would be appreciated
This might do it for you:
"kunal s patel" <email@example.com> wrote in message
> Hi all,
> I want to insert a combo box in one of the columns of list control. What
> the steps that i need to follow to achieve t...