Hi, I've got a workbook from someone with a veryhidden
worksheet that I need to get to. When I try and set the
properties to either visible or just hidden I get a
message 'Unable to set the visible property of the
This sheet has got some complex formula on that need
ammending to make the front sheet work.
I've got two questions. A) How can I make it visible? B)
Its quite cool, how do I do this to other worksheets?
I believe your Workbook is protected. It's done to prevent unhiding and
Hide sheets with a macr...Restoring minimized window
When a user clicks on a minimized window on the taskbar, the application
automatically restores the window. How is this done programatically? More
specifically, how do you capture the event that a user has clicked on your
minimized window and how do you restore the window.
> When a user clicks on a minimized window on the taskbar, the application
> automatically restores the window. How is this done programatically? More
> specifically, how do you capture the event that a user has clicked on your
> minimized window and how do you restore the window.
To handle t...Center Publisher newsletter in email window
How do I center a Publisher e newsletter in the email window? It defaults to
You can't change the default....
"Maven" <Maven@discussions.microsoft.com> wrote in message
> How do I center a Publisher e newsletter in the email window? It defaults
> the left.
...Windows 7 x64 vs. 32bit games
I got a barebones kit last week with the idea of making it a game monster
that will still be good 5+ years from now, so I beefed up the memory to
8GB. *now* I understand that only 64bit OSes can see beyond 4GB. So
fine, I'll install the 64bit version of Windows 7.
The thing is, mostly I got it to run games already in my collection --
Call of Duty, Age of Empires, etc.
Will those run OK on the 64bit platform? Do I need do run them in XP
Compatibility mode or otherwise do anything funky beyond install and play?
Conversely, if they will NOT run on the 64bit version, what...Windows Vista, Office 2007 macros enabled
How best to set the functions so that individual users don't need to enable
macro functions in the same internally generated Access database each time
they log in. I understand that not all macros should be allowed
automatically but this would be an internally created database with only
Adding a self-signed certificate for the workstation?
Follow these instructions for adding a trusted location:
Access World Forums ...Compile error in hidden module: ThisWorkbook
My company currently uses Office XP SP2 and Project 2000 SR1. When we
uninstall Project 2000, and try opening Excel, we receive the following error
Compile error in hidden module: ThisWorkbook
Can you tell us why are we receiving this error. I looked at Tools -
References and did not notice anything missing.
Thanks in advance.
You mighthave an add-in under tools>add-ins associated with Project, if you
can't figure out which uncheck all add-ins, then restart excel, if the
problems go away check one at a time (and close and restart excel) until you
get the error agai...Hidden Worksheets at Start-up of File Q
I have the following code which fires on opening of my workbook, problem is
I am getting an 'object defined' error. I think its because I have hidden
worksheets within the workbook, well at least it worked when I had none of
the sheets hidden. How can I work-around this leaving the worksheets hidden?
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Dim sh As Worksheet
Range("...Calendar Appointments with a hidden CC
This is a tough problem to describe but I'm pretty sure its an
Exchange issue and not Outlook. When inviting one particular user on
a Calendar appointment a former employee is copied on the apponitment
generating an NDR. The user has been deleted from AD and no longer
has an email box on any Exchange server. Calendar invites from any
user in the domain generate this behaviour.
Through message tracking I can see that the email is indeed directed
to the ex-user's mailbox. In message tracking the recipient is listed
as "/O=HMS/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=SCAI...Windows 7 integration
Am having to venture now into starting to deploy Windows 7 Pro into our
AD (2003) environment. Current platform is all XP SP3/ Server 2003 based.
All of my users are set as local admins via group policy. And I need to
try and understand how that plays into UAC and Admin rights in Windows 7.
Using an existing 2003-AD Domained account, I can't see to install
applications without having UAC kick in and ask for elevation.
When I put in my normal-user account details, it fails and repeats. I
have to enter a domain-admin account login to get the softwa...Problem with referencing a hidden column
The code below works great, that is until I hide column Q. I do not want
the data in column Q to me visible on the worksheet. Is there any way around
TextBox100.Value = Range("Q4").Text
TextBox200.Value = Range("Q49").Text
TextBox300.Value = Range("Q94").Text
TextBox400.Value = Range("Q139").Text
TextBox500.Value = Range("Q184").Text
TextBox600.Value = Range("Q229").Text
TextBox100.Value = Range("Q4")
"ordnance1" <ordnance1@comcast...Windows XP backup to flash drive Fails
Hello -- I'm having a problem with the Windows backup utiliy.
Specifically, I tried using the Windows backup wizard to make a
backup of my C drive ( system) and D drive ( user files), which both
add up to about 24 GB. I bought a 32 GB flash drive to do the
backups. However, when the program backs up about 4 GB, I
get an error that says "tape full, insert new media". I have tried
this several times with different parameters, with the same result
each time (stops after 4 GB). Re-inserting the same flash drive
FYI -- I am running Windows XP Pro on a So...Hidden data
Hi. I have a line chart that is in a worksheet with the
data below it. There is one series where the value will
always be constant. I have two questions:
1) Is there a way to have the series in the chart "point"
to one cell so that each y coordinate will be this value
for each x point in the series.
2) If not, is there a way to "hide" the rows containing
the constant series? If I hide the row now, the series
disappears from the chart.
With an "XY (Scatter)" chart with an arithmetic scale for the x axis, it
is fairly straightforward. A...Windows Update Issue on Server 2008
I am running a Windows 2008 SP1 server, as a domain controller.
Windows updates has failed to install the following update;
MS SQL Server 2005 Express Edition with Advanced services Service Pack 3.
It fails as soon as i try and and install it, almost like it's not trying at
The error i get is 80244019, but there are so many different workarounds i
don't know which one works. Has anyone got the same setup and experienced a
Thanks in advance.
...What does that pale blue envelope with a red question mark on it mean?
It shows up in the column marked "!". I have been using Money for years and
never saw it once until this month, when it started appearing for a few of
my transactions. I checked in Help but couldn't find anything about it.
from the online help file
Money detects if you enter similar transactions on multiple occasions
and marks the transactions in the register with a <Blue envelope with
red ?> to flag them as potentially recurring. These marked transactions
will also be listed on the Accounts & Bills view of the Home page under
Potential Recurring Transacti...Outlook XP on windows 2000 #2
I am using the following version of Outlook "Microsoft
Outlook 2002 (10.4510.4219) SP2" on Windows 2000. The
problem I am having the name resolution from the address
book is very slow or freezes and I have tried all possible
ways to fix with no avail, is this a know issue. Can
anyone provide me with a resolution. Appreciate any help...
...Stop hidden window from receiving events temporarily?
Is there a way to stop a hidden window from receiving events while it
is displaying a modal dialog? I want to temporarily disable events to
a window during this time to avoid my window proc from being
>Is there a way to stop a hidden window from receiving events while it
>is displaying a modal dialog?
There's no way I know of from stopping a window from receiving
>I want to temporarily disable events to
>a window during this time to avoid my window proc from being
Add a flag and test/set/reset it at the appropriate mo...Document Note in SOP inquiry window
There is a note field to the right of Document No in SOP inquiry window.
Does anyone know which SQL table is used to store the information when a note
is entered into that field?
SY03900 stores all the notes in a company. In the SOP10100 or SOP30200
table the NOTEINDX for that transaction will link to the NOTEINDX in
Dynamics GP MVP
Flexible Solutions - home of GP Reports
"Susan" <Susan@discussions.microsoft.com> wrote in message
news:559E7D40-2CEA-4DFB-8A85-D...XP SP2 Firewall security breach
Came across this today, can't believe what I'm reading, but it seems
microsoft have put in a backdoor to the XP SP2 Firewall! check out this link
...Lauch .RDP from a C# App while keeping taskbar hidden
First: I'm not the best developer so please excuse any noobiness.
I have a friend that a CS teacher and he want to let his students use an
IDE during their exam. To minimize cheating I recommened that he set up
a server with RemoteApp and install the IDE (Greenfoot). Then I was able
to make a little app that will launch it.
I want the app to be on top of the taskbar but I can't do that unless I
set TopMost to true, but then they can't view the RDP session and if I
kill explorer then RDP won't connect.
So the real question is a) can I have an application sit o...Outlook 2007 Today's Windows 7 Updates: Selection does not work any more
I just updated my Win 7 x64 running Outlook 2007 SP2. After the reboot I
cannot select any text any more in Outlook. In addition I installed Lenovo's
Client Security solution/Password manager.
Does any body see this issue, too?
P.S. that's what I just installed:
Security Update for Microsoft Office 2007 (KB951550)
Update for Microsoft Office Word 2007 (KB974561)
Security Update for the 2007 Microsoft Office System (KB973704)
What happens when you try?
Does it work in Outlook Safe Mode?
Start-> type; outlook.exe /safe
If it work now, it is most likely ca..."Compile error in hidden module: GlobalCodeModule"
we have 3 versions of office installed 2003, 2007, 2010. We have had no
problems with that until a week ago or so.
In Word 2003 we have code in a global template which uses a treeview control
from mscomctl.ocx. I'm not sure that this is the problem though. I have tried
to uncheck the reference to theat control and save the template, but then I
get another error message "The disk is full. etc etc". I can't save the
template after removing the reference or doing any other editing in that
This not only occurring on my computer. I suspect a rec...Updates On Windows XP Pro From WSUS
We are using WSUS to distribute our updates to our PC's. How do I determine
which update is not installing properly? Every time I shut the computer off
it is trying to install updates.
> We are using WSUS to distribute our updates to our PC's. How do I
> determine which update is not installing properly? Every time I
> shut the computer off it is trying to install updates.
How To Ask Questions The Smart Way
...Sort Order on Order Fulfillment Window
In the sales order fulfillment window you can sort the lines items by Order
Entered or Site/Bin/Item. Does the Site/Bin/Item only sort by Bin if
Multi-bin is used? I am not using multi-bin but have created bin for each
item in each site on the Quantities/Sites window.
...Cannot resize Window for Money 2003
I don't know how this happened, but I cannot view Money 2003 in anything but
maximized mode. When I click the center window button, it just goes to the
taskbar. When I right-click and select move or size, the cursor goes up to
the very left hand corner of the screen. I can't get a hold of anything,
I am thinking I will have to completely uninstall and reinstall Money (a
reinstall didn't help; it kept my settings), but I find it hard to accept I
can't overcome this trivial problem. Does anyone have a hint for me?
Thanks, Harold Morgan
Start Money. Hit Alt+Space. Hit...linking to a hidden BE on a network share
I would like to link my access FE to a hidden access BE on a network share.
However, this requires that to hide the BE that I put a dot before the name
e.g. (.my_be). Since the BE is hidden I cannot use the link table utility in
Access to find it, nor will this utility allow me to write in the path since
it does not like the dot before the file name. So........ is there a simple
way to set up the links to a hidden BE on the Unix share with a dote before
the name of the BE?
On 01.03.2010 16:51, salmonella wrote:
> So........ is there a simple
> way to set...