IE toolbar problem #2
I developed toolbar for IE in ATL.
Now the problem is that if there are more than 1 toolbar attached in
browser then if u will select toolbar from
View->Toolbars menu and click on my toolbar then sometimes
behaviour changed, means for example there are 3 toolbar installed in
IE like A,B,C
when user select toolbar A from View->Toolbars IE menu
then toolbar B will show/hide and if i will select B then C will
These results changes with different toolbars and no of toolbars.
Sometimes all the toolbars change their behaviour.
can someone help me how to solve the ...Show a From at 1:00pm
I have a main form that the user inputs information into.
I would like to have a window pop up to at 1:00pm as a reminder to the user.
Is this possible?
Message posted via AccessMonster.com
"User via AccessMonster.com" <u36225@uwe> wrote in message
> I have a main form that the user inputs information into.
> I would like to have a window pop up to at 1:00pm as a reminder to the
It i possible to use the Timer event of a hidden form to check Now...Adjusting toolbar size, restore toolbar
I use MSN stock quote add-in. This has a toolbar w/ several buttons on it.
However, I did something the other day and now I can not view all the
buttons. And I can not adjust the width by "dragging". How can I restore
the toolbar or adjust the width. I also unistalled and reinstalled the
add-in, but it did not help
Try View > Toolbars > Customize
"Josh M" wrote:
> I use MSN stock quote add-in. This has a toolbar w/ several buttons on it.
> However, I did something the other day and now I can not view all the
> buttons. And I can n...select workbook macro
i have been struggling with a macro to select a workbook if it is open, and
open it if it is closed. the details are as follows.
workbook to be opened is S:\QUOTE REGISTER updated
( select sheet year to date )which i can do!!there is a password of babylon
if the book is closed, then it needs to be opened and sheet selected.
if the book is open, then it needs to be made active and sheet selected.
i just cannot seem to do it.
On Error Resume Next
Set oWb = Workbooks("QUOTE REGISTER .xls")
On Error Goto 0
If oWB Is Nothing Then
W...Transparency/blur issue with dynamic toolbar
I'm building an add-in that creates a new tool bar on the fly.
Icons/images are copied and pasted from hidden add-in sheet (I'm not
dealing with face ids).
Issue : my icons/images are 16x16 PNG or GIF with transparent
background copied or inserted from Fireworks. When they are copied to
the Excel sheet or from Excel sheet to the tool bar then they get
blurry (resolution issue it seems..?). Could it be related to
Question : how to handle images transparency and resolution when
building a dynamic tool bar in Excel?
Many thanks for your help.
I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I can
enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is in
Thanks for any help
If A1 is not M,C or V you get a blank
If A1 is not M,C or V you get a zero
Not case sensitive
&qu...help with a formula please #2
I have a long list of numbers (over 600) in a single column, say they are in
A1..A600 (they are daily meter readings) .
In column B I want to subtotal them in groups of 30, or 90, or 365 , or 7,
where the number of days being subtotalled is specified in another cell ?
So in B600 I would have =SUM(A571:A600) for 30 days, or =SUM(A511:A600) for
90 days etc. , where the starting cell A571 or A511 is determined by a
number, ie 30 or 90, in cell C600
How do I arrange for the first cell in the SUM( ) formula to be
determined in this way?
Can someone point me in the right dir...Excel toolbars are missing
Operating System: Mac OS X 10.5 (Leopard)
For some reason, and I do not recall doing anything at all, but the FORMAT and STANDARD toolbars are missing (or hidden). If you "View" and then "Toolbars" they both have checkmarks beside them. I logged on to other sites and say a lot of desperate people but no answers.
Help! This make me long for my DELL.
Click the oblong button at the right end of the document's Title Bar to
expand the docked toolbars area - it sounds like you've collapsed it. Does
your Dell or Vista give you the opportunity to take adva...Toolbar
When i used to open up 2 diffrent programs in excel they would be shown
in seperate boxes at the bottom giving easy acsess to cut and paste.
Now for some reason whatever file i open up it just replaces the one
thats allready open. What have i done - It makes my work so
complecated. PLEASE HELP
jhill's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23274
View this thread: http://www.excelforum.com/showthread.php?threadid=382476
jhill: Check your setting in Tools>Optio...Creating a tally formula
I have a guy that is wanting a formula created so that he can tally ho
many people are going to be attending a golf tournament. He has all th
names in a column and all of the yes s in another. He wants a formul
that will count how many yes s there are above
I cant think of the formula to create. Can anyone assist?
Message posted from http://www.ExcelForum.com
if "yes" is in column B, then a formula that will work i
=counta(B2:B50), or however far down you need it. the formula wil
count the number of cells with any text in it. Also, you could use
=countif(B2:B50,"ye...Possible to lock a range from calculating formulas?
I have a sheet with two ranges, nearly identical in format and formulas,
where one is a constant update of budgets, forecasts, variances etc. The
other is a revised budget. It has the same fields but I need to lock it in
time and not have calculations done until it is allowd to do so at some
point in the future. When the User checks a box on a form it signifies that
the revised budget has been approved and I would like to stop any more
calculations until such time that the checkbox is cleared and then
Is this clear? Is it doable?
It is diffi...Toolbar
We upgraded to version 10 and now the toolbar won't stay locked when users
customize it. There was a post about this on the board but there isn't a
resolution. Has anyone been able to resolve this?
We've noticed this too.
Anecdotal evidence suggests that it happens when you try and use the
toolbar before it has finished loading - but that might be total
Let us all know if you find a solution!
Do you have the debug menu showing?
There is a known issue when the debug menu...Automatically hide all toolbars and menus in Workbook
Hi. I'm a newbee. I've created a macro which automatically starts windows
timer on Workbook_Open. But users still have an option to start timer from
tools menu and when they do that Excel just stops responding. And there are
a few more reasons to hide all the toolbars in this particular workbook.
the same time if user has any other workbooks open he'd have all tools and
menus available for those workbooks. Is there any way to do that with VBA?
Any help on this is much appreciated.
...Stacked Bar graph
This is probably an easy question for most of you but I am not an avid Excel
user, or really a basic user at all.
What I have is data from a survey that I am trying to graph. I have a
question1, an average response number, and a desired response number. I need
to create a single bar graph showing bot numbers in that bar by different
colors as the "stack." Can someone help me with how the data needs to be
setup and if there is anything else I should know. I am using Excel 2007
I would think a line chart would be better, with one series each for average
response and desired...custom toolbar looses buttons when closed
Hi all, I've crossposted to three groups as I'm not sure of the best
location. Apologies if this breaches protocol.
my custom excel toolbar (office97) with macros linked to 3 buttons worked
fine in Windows NT, but a recent enterprise wide upgrade to XP has resulted
in the buttons on the toolbar dissapearing each time Excel is restarted. I
understand this is because the C:\ drive is locked locked down to prevent
changes. While I understand this will be rectified, IT changes are slow in
I also understand this prevents me changing the default file locations an...Newly installed SDRAM is only partially showing up.
Sorry if this isn't precisely Windows related,
I just added two 1-GB sticks of SDRAM into my Dell computer to bring it up
to 4 GB, but it's only showing up under System as 3.25. Which is interesting.
My tower has four RAM slots. When I bought the computer it had four 256 MB
sticks (1 GB), two of which I replaced with two 1 GB sticks a while back
(2.5) and today I replaced the remaining two 256 MB sticks with two 1 GB
sticks to bring it up to 4 GB.
When I turned my computer back on, I was notified that my computer's memory
had changed, giving me the choice ...About a format control toolbar
As we know, when we are using Outlook Express, we can edit the letter using
HTML format, and Outlook Express will give us a toolbar to do that.
I wanna use this toolbar in my VC6 application, but how can i load this
toolbar? Is it an ActiveX control or a DLL library or a class?
Can anyone tell me how can i do that, or how can i implement that function
in an easy way?
...[Entourage 2004] Show me the date!
How can I force Entourage 2004 (SP2) to sort mails by received and
at the same time show me the receive date instead of weekday and
It doesn't work to disable 'Use relative dates in lists (Today,
Yesterday)' in General Preferences > General. It still shows me
weekday and time instead of the date.
Under the "View" menu, set "Preview Pane" to "Below List" or "None". If the
Preview Pane is set so that it is "On Right", the message list will always
use relative dates. I agree that it is an unfo...How to have different sized icons in same imagelist for Toolbar
I am creating a toolbar in VC++ for IE.In my toolbar I am using
ImageList for placing different icons for the toolbar buttons.But the
problem is that all icons are having the same size.I want to have
different size images.How can I do it?Here is my code:
HICON hMotley = LoadIcon(_Module.GetResourceInstance(),
HICON hMotley1 = LoadIcon(_Module.GetResourceInstance(),
m_hImageList = ImageList_Create(28,16,ILC_COLO...do not show query field that does not contain data
I am attempting to create a query in where any field that does not contain
data in relation to the criteria specified will not be shown in the results.
I am aware of the show box however this will not show the field whether it
contains data or not. Please help.
You cannot show or hide a field in different rows of a query. All rows in a
query result will have the same columns. If you want to show or hide entire
columns based on whether or not any record (row) in the result has data in
that column, you could do so by using some VBA to build the query string on
You ...Please Help: Simple Formula
hey everyone. i need a quick formula for excel. i need to subtract row
from row 1 and then divide by row 2. so an example: (B1-B2)/B2 . thi
formula works but i need to do it for the whole column. s
(Bn-Bn+1)/Bn+1. get it? please help me ou
Johnny3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1675
View this thread: http://www.excelforum.com/showthread.php?threadid=31957
See one reply to your later post. Please don't post essentially the same
question multiple times. It ta...Toolbar in CView
I have an SDI application with multiple CView and CHtmlView's devided by
CSplitterWnd. I want to add toolbars to some of the panes (Not to
CMainFrame). How can I accomplish this?
Tobias Svensson wrote:
> I have an SDI application with multiple CView and CHtmlView's devided by
> CSplitterWnd. I want to add toolbars to some of the panes (Not to
> CMainFrame). How can I accomplish this?
> /regards Tobias
One way is to fill the splitter pane with a CFormView. Then put a
toolbar on the CFormView using the method shown in the DLGCBR32 MF...Toolbar
Just installed Office Professional 2007. Publisher is not displaying tool
bar at the bottom of a document that shows the number of pages. Anyone know
how to access this? I've already gone into view toolbar.
There is a registry fix:
Read the sixth FAQ here:
"LOTH" <LOTH@discussions.microsoft.com> wrote in message
> Just installed Office Professional 2007. Publisher is not displaying tool
> bar a...Formula to find the first/third monday of each month.
I need a way to calculate the first/second monday of each month.
I have tried using the weeknum formula among others but this only give
returns the number within the year.
Any help will be very much appreciated
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
1st & 2nd or 1st & 3rd?
You'll need to play around a bit (return type for WEEKDAY always does my
head in), but assuming you have dates in A1, A2, etc. In B1,
=IF(WEEKDAY(A1,2)=1,A1,A1+(8-WEEKDAY(A1,2)))...add vertical line to floating bar chart, still trying
still no luck trying to follow
when i create and paste special the new series, the one that should end up
as the vertical line,
there is no new plot on my chart that is available to be selected to specify
that it be a say a xy scatter chart,
and then after that go ahead and work the secondary axis adjustments etc.
i have 2 series currently on the chart, each one creates 2 floating bars and
the x axis values are set by a macro
so that the bars are floating in a relevant price range, eg if the longest
bar is say 50-60 the x axis ranges f...