IWebBrowser2 control in dialogI have the above mentioned control in a dialog and would like
to remove the vertical scrollbar from the dialog. If I resize the
dialog the vertical scollbar becomes disabled but I would like
it to disappear completely. I've tried:
cs.style &= ~WS_VSCROLL;
in the PreCreateWindow() of the dialog but that doesn't work.
What's the proper way to do this?
Thanks,
Drew
"Drew" <dam@dam.dam> wrote in message
news:%239S1b8HgIHA.5036@TK2MSFTNGP06.phx.gbl...
>I have the above mentioned control in a dialog and would like
> to remove the vertical scrollbar fro...
Sheet ProtectionI am trying to protect specific rows and columns on a worksheet. I select
all, go to protection and uncheck the locked cells box. Then highlight the
rows and columns I want protected, go back in to lock the cells via right
click>format cells and it tells me "Cannot change part of a merged cell."
what am I doing wrong here?
As far as I can see what you are doing is right.
I have just checked what you have done in EXCEL 2007 and do not get the same
warning: it works for me.
Where are the merged cells? In the protected range or out of it? I tested
with both a...
password protect outlook 2007hi
I tried to put password on pst file to lock up the outlook
but everytime I open outlook, it dosen't ask me for the password
how can I add the password to outlook so that even when I logon to the
computer
outlook will still ask for password to open? (under windows vista)
thanks
That usually means that Outlook did not close correctly. Use task =
manager to kill all Outlook.exe processes.
Some common reasons why Outlook will not shut down completely when you =
click either the X or Exit:
1. PDA synchronization software with your PDA in the cradle.
2. WinFax Pro (especially 10.02 ...
Unable to enable password for PST fileUsing Outlook 2002 with pop email account and fax receiving
system. If I enable password for data file (pst), outlook doesn't
prompt me for password on startup.
Any ideas?
Tom in VT
Does Outlook close completely on this machine? Use task manager to verify.
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
reading.
After searching google.groups.com and finding no answer
Tom <tsa68@adelphia.net> asked:
| Using Outlook 2002 with pop email account and...
password protected file with pivot table errorsHey friends,
We have a big problem, around 20% of the times we save workbooks with pivot
tables inside and protect them with password for opening the file - the file
get ruined!
In those times, when we open the file (the password protected file with the
tables inside), excel ask me for the pass (ok, I give it) and then say "file
opening did not succeeded", and then let me type again, in the second time it
opens but give a message saying "there where errors in the file, and changes
where made:" (and then a list of my pivot tables saying that fixes made to
them).
Fr...
OLE control does'nt work with dllHello,
The exe program does very well when inserting an Excel range from
Excel in an OLe control in a vb6 form, with:
XlApp.Range(xxx).Copy
me.OLE1.Paste
But when the exactly same program is executed as a dll, the OLE
control resizes itself but does'nt display the Excel range. No error
is fired
Any help
Thanks
Avi
...
What controls what appears in the Title Bar?I have a user who usually runs Outlook 2007 with several calendars open:
her own, and calendars of two other people in her department
If she has only her own calendar open the title bar says 'Calendar -
Microsoft Outlook'. If she has these shared calendars open, the title bar
shows the name of one of the people who's calendar she has open, i.e. 'Bob
Smith - Microsoft Outlook'
She would like the title bar to display 'Calendar - Microsoft Outlook' all
the time, regardless of who's calendar she has open.
Can this be done?
Thanks,
Jim
By the way, our back...
How to release a CWebBrowser2 control?Dear everyone:
I have a CWebBrowser2 control on my dialog and navigate to url by the
following code:
CComVariant sNull,sFrame;
sNull="";
sFrame="";
m_ctlWeb.Navigate("http://www.microsoft.com",
&sNull, &sFrame,&sNull,&sNull);
When I close the dialog and try to release the control by the following
code:
m_ctlWeb.DestroyWindow();
The control is destroyed, but when I check the task manager for the
memory usage, I found that a memory of over 11 megebytes still remained! Can
anyone tell me how to release the memo...
No Sound no volume control in notification areaI updated to a new driver from Windows and my sound is gone and the volume
control icon by the clock is gone. I tried to roll back but no drivers to
roll back too. System restore also did not work. Shoots. What now?
This is not a Windows group. Do not upgrade a driver from the Microsoft web
site. Go to the manufacturer's web page and get the update there. Have you
re-booted?
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"RiderDubs" <RiderDubs@discussions.microsoft.com> wrote in message
news:D617B57B-6C3...
Move Control to another Form ProblemThis Control Button I want to move from my MainMenu Form to the form that contains the the List Box [lstModify], which is where my Invoices sit to be distributed, When I moved the control I got a yellow error on {subSetInvoiceValues} thanks for any help......BobPrivate Sub cmdDistributeAllInvoices_Click() Dim nRtnValue As Integer nRtnValue = MsgBox("Are you sure you want to Distribute All Invoices?" & vbCrLf & vbCrLf & "If you choose Yes, all the Invoices will have Invoice Numbers.", vbCritical + vbYesNo + vbDefaultButton2, "Distribute all Invoices"...
Controlling decimal digitsHi
I have a few numeric hours appear on a report like this;
2
9.75
12.5
This is all fine but when a number like 1.83333 appears I only would like it
to limit to two decimal places as 1.83. How can I achieve this?
Thanks
Regards
On Mon, 1 Mar 2010 06:48:35 -0000, "John" <info@nospam.infovis.co.uk> wrote:
>Hi
>
>I have a few numeric hours appear on a report like this;
>
> 2
> 9.75
> 12.5
>
>This is all fine but when a number like 1.83333 appears I only would like it
>to limit to two decimal p...
Preventing other users saving another version of protected workbooI have protected a workbook with locked cells and unlocked cells that can be
edited. I would like to prevent the user from "saving as" and abusing the
protection. Is this possible?
Saving As will not alter the protection.
"Laura Cook" <laura.cook@strand.ltd.uk.(nospam)> wrote in message
news:B8ED3CA2-108C-48D3-8D08-FA233E136A7B@microsoft.com...
>I have protected a workbook with locked cells and unlocked cells that can
>be
> edited. I would like to prevent the user from "saving as" and abusing the
> protection. Is this possible?
...
Hosting windowless controlI have a windowless control - it has to be windowless because it's not
rectangular. I have used it many times in VB applications without problem.
Recently I tried to include it in an MFC dialog box and it doesn't work. It
appears to be being drawn with a control window.
What happens is that MFC blanks the rectangular area of the control site to
white before invoking the control's draw function.
Debugging through the control (which is ATL), I have discovered that when
the host is a VB application it is, indeed, windowless (control's bWndLess
member = TRUE) but when hosted fr...
Scrolling a static control?Given a narrow "static" control on a dialog, it's text can be set using
SetWindowText("Some looong text here...."). That same long text can be
retrieved with GetWindowText(). What's missing is the ability to select the
text while holding down the left mouse button. Enabling the SS_NOTIFY style
on the control itself will notify the parent of things like WM_LBUTTONDOWN,
WM_MOUSEMOVE, and WM_LBUTTONUP messages, but can anything be done to scroll
and select the text?
Thanks,
DC
You cannot do that with a static control. An alternative is to use a
CEditBox control ...
tab control problemI set up a series of automated tabs.
Ex. user hits a button, focus shifts to an unbound box in a tab. That unbound
box has a "on focus" macro that goes to an unbound box on a second tab, which
has a "on focus" macro that shifts focus to a third unbound box on a third
tab, etc. The problem becomes when I have more than one leap, an error
message comes up saying that I cannot change focus to the 1st unbound box.
The error message appears for every box in tries to access, but the focus
ends up where I want it to be.
My question is: was does it says this, but work anyways? ...
Stop sheet showing when Using Datapig's Force Users to enable macrHi,
I think this is probably not do-able
I'm using Datapig Technologies example to force users to enable macros
When the workbook is closed all sheets other than a warning sheet are very
hidden so that if the workbook is opened with macros disabled then the user
can only see a warning sheet saying to close and open with macros enabled.
Then on opening with macros enabled the waring sheet is very hidden and the
other sheets can be seen.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
Sheets("Warning").Visible = True
Sh...
Stock control questionAlthough I have used Excel for years I have never had the need to use a
complicated formula.
I am trying to set up a stock control spreadsheet where multiple items are
deducted when I click on one cell.
What I am trying to do is each time I click on cell A3 "Item" all the
amounts in C will be deducted from D and the difference between B and D will
show in E
A B C D
E
1 Normal Amount In stock To
be
2 Stock level...
resize textboxHi there, I'm struggling to resize the textbox on the MS CRM form. for
instance initial field- max 2 characters.Can anyone help. Thanks in advance
--
donn
Go to attributes and edit the Max Length value of the textbox in question.
Regards
Steve
"Donald" wrote:
> Hi there, I'm struggling to resize the textbox on the MS CRM form. for
> instance initial field- max 2 characters.Can anyone help. Thanks in advance
> --
> donn
I'd like to make a quick mention here about past experience with
resizing text boxes.
If you are inserting data from .NET applicatio...
Prompt to save when using a tab controlHi there
In my database, I have a form which consists of 5 tabs.
When a user moves from tab to tab, is it possible to set a prompt that
prompts the user to save their work?
I have users who think that this is a necessary feature of my database.
Thank you in advance for your help.
On Sun, 21 Mar 2010 17:29:01 -0700, forest8
<forest8@discussions.microsoft.com> wrote:
>Hi there
>
>In my database, I have a form which consists of 5 tabs.
>
>When a user moves from tab to tab, is it possible to set a prompt that
>prompts the user to save their wor...
CScrollView within an ActiveX ControlI am trying to create a CScrollView and make it a child in an ActiveX
Control.
1) I used the VC++ "Add Class" to derive from CScrollView, getting
MyScrollView
2) #include'd the header file and delcared a member of that derived class
"MyScrollView m_View"
3) When I attempt to create it, the compiler tells me that I can not call
the "protected" construtor.
I then tryed to create the derived class via a "new" , dynamically. Got the
same error.
and Ideas?
PinHead wrote:
> I am trying to create a CScrollView and make it a child in an ActiveX
&...
Protect or Unprotect Cell dependent on different cellI am trying to find a way of automatically protecting a cell if an adjacent
cell has a specific value whilst if that cell has a different value the cell
would be unprotected.
For example if I am aiming to have a column with values in that will be
entered but if a field next to it has a 1 in the value field will then be
locked. But if the 1 is changed to a 0 the value field could then be edited.
Many Thanks for any help.
David
You could do this with a worksheet_change event to make it fully
automatic.Unlock ccell f1>protect the sheet>right click sheet tab>view
...
Updating dialog controlsHi,
I have a SDI application written with Visual C++ 6.
The view is a CFormView. The first dialog in the CFormView has CTabCtrl to
switch between dialogs.
When I open a file, I want that the data ,in this file, to be put in the
differents controls of all of the dialogs.
But I don't know how to do this.
I think I have to do this in the CFormView OnUpdate member function. I have
tried also mTab.UpdateData(FALSE), but without success.
Does anyone has suggestions ?
Thanks,
Claude
Claude Gagnon wrote:
> Hi,
>
> I have a SDI application written with Visual C++ 6.
>
>...
Re: protecting worksheet corrupts fileI have tried several different methods including:
ActiveWorkbook.Protect "Password"
Dim objSheet As Worksheet
For Each objSheet In Worksheets
If objSheet.ProtectContents = False Then objSheet.Protect "a@#&ladfl&^"
Next objSheet
or
With ActiveSheet
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, Password:="Password"
End With
or
ActiveSheet.Protect UserInterfaceOnly:=True, Password:="Password"
even just
ActiveSheet.Protect Password:="Password"
Nothing works, I have macros that need to have ...
can you control how comments print in excel xp or 2003?I noticed a user at the copier today, using the blow up function to
try to enlarge the comments that he had printed out at the end of his
excel worksheet. He commented that he could not change the font for
the comments. I went back to my desk, and was able to replicate the
issue...
In short, you can format comments for on-screen viewing (and
presumably when you print comments "in place"), but if you print out
all the comments at the end of your document, you apparently can't
control the font/size/formatting/etc. The only thing I could find that
made a different to how it printed...
How to password protect a webpage in publisherI have a website built and published with Publisher and want to password
protect a page on the site. How do I do this using Publisher.
Thanks in advance
--
Wayne Edgin
Step one: Verify with your ISP that it is allowed.
I can tell you how I do it with a Publisher 2000 site.
Post your Publisher version and site address.
--
Don
Vancouver, USA
"Wayne" <Wayne@discussions.microsoft.com> wrote in message
news:299AAF1E-73F0-4ABB-91CD-74ED83297996@microsoft.com...
>I have a website built and published with Publisher and want to password
> protect a page on the site. How...