Hide or show Tag from VBA
When I rightclick a shape I can hide or show it's Tag.
What are the commands to do that from VBA?
Not exactly sure what you're talking about, but I'll take a guess.
The shape you are using has a custom right-click, or context menu that
allows you to hide and show some graphics.
Inside the ShapeSheet for this shape is an Actions section. There will be a
formula under the hide/show rows that looks something like one of these:
SetF( "User.TagVisible", Not(User.TagVisible) )
SetF( GetRef( User.TagVisible ), Not(User.TagVisible) )
What you are looking for is th...Prevent Viewing on worksheet
I want to prevent some other one can view some of worksheets in my
workbook. Although Excel can hide the worksheet, it can be unhide again
without protection. Does anyone know how to do so?
In article <e8qbxl2uGHA.5056@TK2MSFTNGP06.phx.gbl>, "Ellis Yu" <email@example.com> wrote:
> I want to prevent some other one can view some of worksheets in my
>workbook. Although Excel can hide the worksheet, it can be unhide again
>without protection. Does anyone know how to do so?
If you don't want others to...Showing all data in tabular form boxes
I have a columnar form with tabular subform. The data was all imported from
Works and therefore some of the fields have a great deal of data. In the
tabular subform I would like to keep the boxes with just first row of data;
i.e. small, but be able to show all the data in a separate box elsewhere
should it be wanted. I would be really appreciative if someone could come up
with a suggestion as to how this could be done.
Move the cursor to the text box and press SHIFT + F2 and see if that
will do what you want.
On Thu, 17 May 2007 03:20:01 -0700, Sadie
<Sadie@...showing a dropdown list dependent on what's selected in the previos drop down box?
In Column 1 I have a drop down box with all of the makes of vehicle
(Chevy, ford, dodge, etc...). In Column 2 I have a place to type i
I want to make a dropdown box in Column 2 that will show me all of th
available models for a particular brand. (If Chevy is selected i
Column1, then only Chevy models will be displayed in the dropdown bo
next to it.) Like they use on web pages like kelleybluebook.com an
lherndo's Profile: http://www.excelforum.com/member.php?action=getinfo&am..."Computer Locked" dialog does not show up
I have windows XP Pro (version 2002) SP3.
When I lock my computer, I do not see the "Computer Locked . . . " dialog.
Instead, I only see the "Unlock Computer" dialog immediately upon locking.
I am concerned about not pressing Ctrl+Atl+Del before entering my password
Is there a setting that I can change (I have extensive knowledge of windows
registry and system tools, but I have not been able to find an option to
"Show only unlock screen".
...Showing Discounts in Exp Report
The reply shown below form Chris Cowles and it works.
Except discounts do not show up in the expense report.
Hopfully they would show as a negative number. They show
not at all. How can I get discoounts to show up in expense
If you're recording discounts, I don't think it's an income
- it's a
reduction in expense. For the purposes of income
statements, there is a
I think the correct way to record this would be:
...How prevent input mask appearing in locked date field?
When user clicks in a date field that has enabled = false, locked = true,
the input mask appears even though no data can be entered. Seems like an
Access bug. How to prevent mask appearing?
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
This is no problem for me in Access 2003! When a control is set to
Enabled = False
Locked = True
Access won't let me move into the control!
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message po...Cash Flow doesn't show up anymore
Suddenly I can't get the cash flow work. I have tried everything suggested.
Removed all bills, closed all accounts, repaired the money file, removed the
budget and reset the debt plan. The cash flow still do not show up. It used
to work until a few days ago. Any suggestions?
...Will I get 4 post cards to a page in Publisher 2007? It only show.
I am creating a post card on my lap top. I do not have a printer with me to
test prints. The Print Preview shows 2 cards in portrait format. I want 4
cards in landscape. Can someone offer some help?
In Publisher 2000 it is;
from the list, select
then select any of the six displayed
Edit to your preference
On the Print window, select
Select, Print multiple copies per sheet
"Darleen" <Darleen@discussions.microsoft.com> wrote in message
&g...Prevent Deletion of emails from Shared Mailbox
I have a Remote Exchange Server and my users access shared mailboxes via OWA
by opening another mailbox option. Can you advise how can i restirct my users
from dleeting the email items from the shared mailbox. I just want them to
Read / Reply & forward Emails. But not to delete any items from the box
I believe that you cannot achieve that on any version of Exchange,
"Sanjay Mishra" <firstname.lastname@example.org> wrote in message
> I have a Remote Ex...How to show attached images in mail automatically
i am desperately looking for the option to see attached pictures in a mail
directly, as OE does.
i found the following in the help-file of outlook:
Customize how the screen reader sees attachments
1.. Use the keyboard to choose the Customize Current View command (View
menu, Arrange By, Current View submenu).
2.. Click Fields, and then click New Field.
3.. In the Name box, type a name for the field, such as Attachment
4.. In the Type list, click Formula.
5.. In the Format box, type:
6.. Cl...Showing intenet headers on recieved mail
How? I can see how to do it in OE but not Outlook....
"Paul Williams" <paulfoel@nospam_hotmail.com> wrote in message
> How? I can see how to do it in OE but not Outlook....
...How do I show Free/Busy calendar status between Exchange 2K and 2K3 Servers?
I have recently moved my mailbox from a native Exchange 2000 to an Exchange
2003 server within the same site.
What do I need to configure, so that I can see the Free/Busy aviliability of
people I attempt to schedule in Outlook, who's mailboxes
still reside on the Exchange 200 server?
I have a csv! file with the number 90E0014 as one of the
fields. Opening it in excel causes it to be displayed as
9.00E+15 though. I don't want this to happen.
Actually, there's many numbers that have the E in it
that's displayed that way in this csv file.
I've tried putting quotes (") around each field,
but this doesn't help.
Same concept applies with dates - ie. if you enter 1/02 -
it's displayed as 2nd January
How do I get this to NOT automatically change the contents
when displaying it in excel.
Remember, this is a csv file, not a workbook - this does ...I have text in an Excel Cell that isn't showing all of it?
I have Text in Excel that will not display..meaning its a lot of text and
only part is showing. I have selected wrap text and auto fit for column and
row height. I can expland the cell but the text wont show (all of it)...it
shows up to a certain point.
This is from a reply written by Cyber Taz. The question is similar to
Cells were never intended to store large volumes of text. They have a
of 409 points in height (roughly 34 lines of 10 pt. type, assuming 120%
leading). There is also some technical glitch with content that falls
the 256-1024 character...Email Marked Open Automatically
I apologize for posting this in two forums, but it's an odd problem and I
don't know which provides the best shot for an answer.
I've got a weird problem and I can't find any reference to it. It is
only happening to one user in our domain. We are running Exchange 2003 on
Win2003 and the the user is primarily using Outlook 2003 as a client. Here's
what is happening:
Within 30 seconds or so of arriving (obviously) un-read, email is marked as
Read. You can see the little envelope icon change and the font goes from
bold to regular. Apparently, it changes whether ...How do I get it to show page icons at bottom of screen
On one of our computers the page icons do not show up at the bottom of the
screen. To change pages I have to click the "go to" page. How do I get the
page icons to appear?
Take a look at the sixth FAQ here:
If you have any version other than 2007, View, Status Bar
"saleshire" <email@example.com> wrote in message
> On one of our computers the page icons do not show up at the bottom...Need help with Indexed View that shows lowest prices
In my system, there are products and multiple vendors selling the same
products. I want to create an Indexed View that shows me the 10 vendors with
lowest prices for each product in the database. So if 20 vendors sell iPod at
varying prices, I want my Indexed View to show 10 lowest prices and the
vendors who offer them.
I'd appreciate some help with the SQL for this. Please find the SQL scripts
/****** Object: Table [dbo].[Vendors] Script Date: 11/24/2009 21:48:20
SET ANSI_NULLS ON
SET QUOTED_IDEN...Preventing user name from appearing in new cell Comments.
I use the comment feature in Excel 2000 regularly. Every time a new comment
is started, my user name in bold appears. I always have to overwrite it an
turn off bold text before I create the comment.
As I am the only user on this computer, and I do not share the information
on-line with any other users, can some Excel expert please tell me how can I
turn off the automatic insertion of my user name?
] XL2000: Sample Macro to Remove User Name from Comment
David McRitchie, Microsoft MVP - Excel [site changed Nov...Attaching picures to show in Outlook
When I used outlook express as my email client, the attached pictures showed in the body of my message
I would like to have the pictures show in Outlook the same way
How do I do it?
Not possible - Outlook does not display pictures as Outlook Express does.
Different programs - different behavior.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, LP asked:
| When I used ...Preventing
Dear sir, with best regards,i have some special workbooks,like to prevent
anyone for copying or transfering datas from them or their sheets. is it
possible in excel 2003.
Message posted via OfficeKB.com
You can apply a password and protection to your spreadsheet; however it is
not difficult to circumvent passwords in Excel.
If you have data that must be kept secret, do not distribute it in Excel!
"tofimoon3 via OfficeKB.com" wrote:
> Dear sir, with best regards,i have some special workbooks,like to prevent
&...Why don't invoice payments show up as income?
I receive payments on invoices, and a deposit is automagically entered into
the correct account registry with a Category of "Payment for Invoice".
However, the invoice payments do NOT show up as income in the Business
reports. Why not?
I want and expect the Business Profit & Loss Statement to show invoice
payments as income...
Have I configured something incorrectly or failed to configure something?
Money 2005 Small Business; Version 220.127.116.115
...debugger shows the first character of a string only
In VS 6.0, the debugger shows the first character of a string only.
(variable of type CString).
Is it possible to see the whole string?
Thanks for ideas
> Hi all,
> In VS 6.0, the debugger shows the first character of a string only.
> (variable of type CString).
> Is it possible to see the whole string?
> Thanks for ideas
You probably need to select "Decode Unicode Strings" under
Something I do often:
1. Open a memory window.
2. Add the CString to your watch window.
3. Open it ...Prevent bounce
I run an Exchange server behind a mail relay. The relay cannot decide which
mail to reject because it doesn't know the list of valid recipients. So if I
enable recipient filtering on the Exchange server, the relay sends bounce
mails. If I disable recipient filtering, Exchange is the server sending the
bounce messages. Can I somehow solve this situation? Maybe make Exchange
"swallow" the mails, instead of rejecting or bouncing them?
Christoph Kling wrote:
> I run an Exchange server behind a mail relay. The relay cannot...How can I prevent user from resizing fields in subform ?
If a user clicks on the heading of a field in a subform, they can
resize the field. How can I prevent the user from doing this?
Change the default view of the subform from Datasheet to Continuous, and set
the textbox controls for the fields to resemble a datasheet, but with each
control set to the size you want. You can place labels in the subform's
header section to display the field names (column titles).
<firstname.lastname@example.org> wrote in message
> If a user clicks on the heading of a fie...